/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

/*
 * rh_empleados_edita.java
 *
 * Created on 19/10/2013, 01:51:29 PM
 */

package si_rhnominafacilv2;


import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.Calendar;

import java.text.ParseException;
import java.text.*;


import org.jfree.data.category.DefaultCategoryDataset;
import org.jfree.ui.RefineryUtilities;
/**
 *
 * @author michelle
 */
public class rh_empleados_edita extends javax.swing.JDialog {

    si_conectar x = new si_conectar();
    ResultSet rs = null;
    int sexo=0;
    private javax.swing.table.DefaultTableModel jtable_modelo;
    private javax.swing.table.DefaultTableModel jtable_modelo_resxarea;
    private javax.swing.table.DefaultTableModel jtable_modelo_empleado_hist;
    private javax.swing.table.DefaultTableModel jtable_modelo_empleado_ventasxmes;
    private javax.swing.table.DefaultTableModel jtable_modelo_empleadocxc;
    private javax.swing.table.DefaultTableModel jtable_modelo_empleadocxcdetalle;
    private javax.swing.table.DefaultTableModel jtable_modelo_asistenciaxdia;
    private javax.swing.table.DefaultTableModel jtable_modelo_asistenciaxdia_detalle;
    private javax.swing.table.DefaultTableModel jtable_modelo_nominaperodeduc;
    private javax.swing.table.DefaultTableModel jtable_modelo_nominaperodeducem;

    private SimpleDateFormat formateador = new SimpleDateFormat("dd-MM-yyyy");
    private SimpleDateFormat formateadoresta = new SimpleDateFormat("yyyy-MM-dd");
    int controlcombo=0,yacarguecxc=0,indexactual=0,yacargueventas=0,yacargueasis=0,yacarguesal=0;
    private JTable jtable_tiendas;
    private java.util.Date fechahoy=new Date();
    /** Creates new form rh_empleados_edita */
    public rh_empleados_edita(java.awt.Frame parent, boolean modal) {
        super(parent, modal);
        initComponents();
    }
  public rh_empleados_edita(int idemplea,int opcion) {


        this.iniciar_modelo_de_tabla();
        this.iniciar_modelo_empleadohistorial();
        this.iniciar_modelo_resultadosxarea();
        this.iniciar_modelo_ventaxmes();
        this.iniciar_modelo_empleado_cxc();
        this.iniciar_modelo_empleado_cxcdetalle();
        this.iniciar_modelo_asistencia();
        this.iniciar_modelo_asistencia_detalle();
        this. iniciar_modelo_nomperodec();
        this.iniciar_modelo_nomperodecind();
        initComponents();
        this.carga_datos_empleadoform(3,String.valueOf(idemplea));
        this.loadcombodepa();
        this.loadcombostatus();
        this.loadcombopuestos();
        this.loadcombotiposcausabaja();
        this.loadcomboestadocivil();
        this.loadcombo_diadescanso();

        this.jrbtn_sexomasculino.requestFocus();

        jt_catpreguntas.getColumnModel().getColumn(0).setPreferredWidth(10);//tem ent
        jt_catpreguntas.getColumnModel().getColumn(1).setPreferredWidth(260);//subfam.
        jt_catpreguntas.getColumnModel().getColumn(2).setPreferredWidth(60);//subfam.
        jt_catpreguntas.getColumnModel().getColumn(3).setPreferredWidth(10);//subfam.

        jt_catresxarea.getTableHeader().setBackground(Color.yellow);
        jt_catresxarea.getTableHeader().setPreferredSize(new Dimension(jt_catresxarea.getTableHeader().getWidth(),35));

        jt_catresxarea.getColumnModel().getColumn(0).setPreferredWidth(180);//tem ent
        jt_catresxarea.getColumnModel().getColumn(1).setPreferredWidth(50);//subfam.
        jt_catresxarea.getColumnModel().getColumn(2).setPreferredWidth(20);//subfam.
        jt_catresxarea.getColumnModel().getColumn(3).setPreferredWidth(40);//subfam.
        jt_catresxarea.getColumnModel().getColumn(4).setPreferredWidth(40);//subfam.
        jt_catresxarea.getColumnModel().getColumn(5).setPreferredWidth(40);//subfam.

        jt_catempleadoshisto.getColumnModel().getColumn(0).setPreferredWidth(40);//tem ent
        jt_catempleadoshisto.getColumnModel().getColumn(1).setPreferredWidth(60);//familia
        jt_catempleadoshisto.getColumnModel().getColumn(2).setPreferredWidth(160);//subfam.
        jt_catempleadoshisto.getColumnModel().getColumn(3).setPreferredWidth(60);//subfam.
        jt_catempleadoshisto.getColumnModel().getColumn(4).setPreferredWidth(30);//subfam.
        jt_catempleadoshisto.getColumnModel().getColumn(5).setPreferredWidth(160);//subfam.

        jt_historialventa.getColumnModel().getColumn(0).setPreferredWidth(180);//tem ent
        jt_historialventa.getColumnModel().getColumn(1).setPreferredWidth(50);//subfam.
        jt_historialventa.getColumnModel().getColumn(2).setPreferredWidth(80);//subfam.
        jt_historialventa.getColumnModel().getColumn(3).setPreferredWidth(80);//subfam.
        jt_historialventa.getColumnModel().getColumn(4).setPreferredWidth(80);//subfam.


        jt_nomina_peryded.getColumnModel().getColumn(0).setPreferredWidth(20);//tem ent
        jt_nomina_peryded.getColumnModel().getColumn(1).setPreferredWidth(160);//tem ent

        jt_historialventa.getTableHeader().setBackground(Color.yellow);

        this.carga_datos_catempleadoshistorial(String.valueOf(idemplea));
        this.jep_expediente.setContentType("text/html");
        this.jep_expediente.setEditable(false);
        this.carga_datos_expediente(String.valueOf(idemplea));
         if (si_variables.getnivelusu()<3 )
            {
                this.loadcombo_tiendas();
            }
         else
            {
                this.jcbx_tiendas.setVisible(false);
                this.jtf_sieuno.setVisible(false);
            }
        controlcombo=1;
        this.jbtn_guardarcxcmovi.setVisible(false);

        Calendar fechamesini = Calendar.getInstance(); // obtiene la fecha actual
        this.jdc_fechafinal.setDate(fechamesini.getTime());
        //establesemos la fecha en base a la de hoy menos 1 mes en el dia 1
        fechamesini.set(fechahoy.getYear()+1900,fechahoy.getMonth()-1, 1);
        this.jdc_fechainicial.setDate(fechamesini.getTime());
        this.jdc_fechaaviso.setDate(fechahoy);
        this.setTitle("SI Modulo R.H.:Edicion("+this.jtf_empnombre.getText()+" "+this.jtf_empapat.getText()+" "+this.jtf_empamat.getText()+")");
    }
private void iniciar_modelo_empleado_cxc()
    {
        jtable_modelo_empleadocxc=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_empleadocxc.addColumn("<html><b>Status Requi</b></html>");
        jtable_modelo_empleadocxc.addColumn("<html><b>Empleado</b></html>");
        jtable_modelo_empleadocxc.addColumn("<html><b>Docto</b></html>");
        jtable_modelo_empleadocxc.addColumn("<html><b>Fecha</b></html>");
        jtable_modelo_empleadocxc.addColumn("<html><b>Piezas</b></html>");
        jtable_modelo_empleadocxc.addColumn("<html><b>Importe</b></html>");
        jtable_modelo_empleadocxc.addColumn("<html><b>Saldo</b></html>");
    }
private void iniciar_modelo_empleado_cxcdetalle()
    {
        jtable_modelo_empleadocxcdetalle=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>id</b></html>");
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>Docto</b></html>");
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>Fecha</b></html>");
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>Cargo</b></html>");
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>Abono</b></html>");
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>Historial</b></html>");
        jtable_modelo_empleadocxcdetalle.addColumn("<html><b>Observaciones</b></html>");
    }
private void iniciar_modelo_empleadohistorial()
    {
        jtable_modelo_empleado_hist=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_empleado_hist.addColumn("<html><b>Aplico</b></html>");
        jtable_modelo_empleado_hist.addColumn("<html><b>Fecha</b></html>");
        jtable_modelo_empleado_hist.addColumn("<html><b>Nombre</b></html>");
        jtable_modelo_empleado_hist.addColumn("<html><b>Puesto</b></html>");
        jtable_modelo_empleado_hist.addColumn("<html><b>T.Puntos</b></html>");
        jtable_modelo_empleado_hist.addColumn("<html><b>Rango F. Evaluado</b></html>");
    }
private void iniciar_modelo_de_tabla()
    {
        jtable_modelo=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo.addColumn("<html><b>Area</b></html>");
        jtable_modelo.addColumn("<html><b>Pregunta</b></html>");
        jtable_modelo.addColumn("<html><b>Respuesta/valor</b></html>");
        jtable_modelo.addColumn("<html><b>obs</b></html>");
    }

private void iniciar_modelo_resultadosxarea()
    {
        jtable_modelo_resxarea=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_resxarea.addColumn("<html><b>Area</b></html>");
        jtable_modelo_resxarea.addColumn("<html><b>Puntos Logrados</b></html>");
        jtable_modelo_resxarea.addColumn("<html><b>%</b></html>");
        jtable_modelo_resxarea.addColumn("<html><b>Peso</b></html>");
        jtable_modelo_resxarea.addColumn("<html><b>Total(%logrado Vs Peso)</b></html>");
        jtable_modelo_resxarea.addColumn("<html><b>Media Evaluacion</b></html>");
        jtable_modelo_resxarea.addColumn("<html><b>Media Negocios</b></html>");
    }
private void iniciar_modelo_ventaxmes()
    {
        jtable_modelo_empleado_ventasxmes=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_empleado_ventasxmes.addColumn("<html><b>Agente</b></html>");
        jtable_modelo_empleado_ventasxmes.addColumn("<html><b>Mes</b></html>");
        jtable_modelo_empleado_ventasxmes.addColumn("<html><b>Notas</b></html>");
        jtable_modelo_empleado_ventasxmes.addColumn("<html><b>Venta</b></html>");
        jtable_modelo_empleado_ventasxmes.addColumn("<html><b>Prom x Nota</b></html>");
    }
private void iniciar_modelo_asistencia()
    {
        jtable_modelo_asistenciaxdia=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Fecha</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Status Asistencia</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Hora E./H.Prog</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Hora S.</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Comida/ M Prog</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Hrs Trab.</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Observaciones</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Status Revision</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Id</b></html>");
        jtable_modelo_asistenciaxdia.addColumn("<html><b>Puntualidad</b></html>");
    }
private void iniciar_modelo_asistencia_detalle()
    {
        jtable_modelo_asistenciaxdia_detalle=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_asistenciaxdia_detalle.addColumn("<html><b>Fecha</b></html>");
        jtable_modelo_asistenciaxdia_detalle.addColumn("<html><b>Status</b></html>");
        jtable_modelo_asistenciaxdia_detalle.addColumn("<html><b>Hora E.</b></html>");
        jtable_modelo_asistenciaxdia_detalle.addColumn("<html><b>Hora S.</b></html>");
        jtable_modelo_asistenciaxdia_detalle.addColumn("<html><b>Observaciones</b></html>");

    }

private void iniciar_modelo_nomperodec()
    {
        jtable_modelo_nominaperodeduc=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_nominaperodeduc.addColumn("<html><b>Id</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>Descripcion</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>tipo</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>Valor</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>Obs</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>id Pre</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>t.n</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>S.U.</b></html>");
        jtable_modelo_nominaperodeduc.addColumn("<html><b>Calculo base D.T.</b></html>");
    }

private void iniciar_modelo_nomperodecind()
    {
        jtable_modelo_nominaperodeducem=new javax.swing.table.DefaultTableModel();//Creo el modelo
        jtable_modelo_nominaperodeducem.addColumn("<html><b>Id</b></html>");
        jtable_modelo_nominaperodeducem.addColumn("<html><b>Idpod</b></html>");
        jtable_modelo_nominaperodeducem.addColumn("<html><b>Descripcion</b></html>");
        jtable_modelo_nominaperodeducem.addColumn("<html><b>cantidad</b></html>");
        jtable_modelo_nominaperodeducem.addColumn("<html><b>factor</b></html>");
        jtable_modelo_nominaperodeducem.addColumn("<html><b>Salario</b></html>");
        jtable_modelo_nominaperodeducem.addColumn("<html><b>Importe</b></html>");
    }

private void carga_datos_empleadoform(int opcion,String textobusca)
    {
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
        java.util.Date fechaestaeuropa=null;
        String texto="select * from x1_supervision_empleados_actualiza("+opcion+",'"+textobusca+"') as (id integer,nombre character varying(50),nomapat character varying(50),nomamat character varying(50),dom_calle character varying(80),dom_colnia character varying(80),dom_pobla character varying(50),dom_codpost character varying(10),dom_codidenti character varying(20),id_tienventas integer,id_depart smallint,id_puesto smallint,id_status smallint,id_jefeinme smallint,id_tipojor smallint,fecha_nac text,fecha_alta text,fecha_baja text,rfc character varying(18),curp character varying(20),imss character varying(20),foto character varying(80),id_causabaja smallint,id_clasif smallint,id_sexo smallint,id_tiposan smallint,id_stadocivil smallint,id_sieuno integer,id_tipocon smallint,descri_depa character varying(80),descri_puesto text,descri_status character varying(25),descri_jorna character varying(25),descri_baja character varying(25),descri_clasif character varying(25),descri_sangre character varying(25),descri_stadocivil character varying(25),descri_contrato character varying(25),telefono character varying(50),email character varying(50),horae time,horas time,mincom smallint,hora2e time,hora2s time,diades smallint);";
         System.out.println(texto);
        try
            {
                rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                    this.jtf_empid.setText(rs.getString("id"));
                    this.jtf_empestatus.setText(rs.getString("descri_status"));
                    this.jcmbx_stadocivil.addItem(rs.getString("id_stadocivil")+":"+rs.getString("descri_stadocivil"));
                    this.jtf_empnombre.setText(rs.getString("nombre"));
                    this.jtf_empapat.setText(rs.getString("nomapat"));
                    this.jtf_empamat.setText(rs.getString("nomamat"));
                    //this.jtf_domcalle.setText(rs.getString("dom_calle"));
                    //this.jtf_domcolonia.setText(rs.getString("dom_colnia"));
                    //this.jtf_dompobla.setText(rs.getString("dom_pobla"));
                    //this.jtf_domcod.setText(rs.getString("dom_codpost"));
                    this.jtf_codigoidentifica.setText(rs.getString("dom_codidenti"));
                    //this.jtf_domtelefono.setText(rs.getString("telefono"));
                    //this.jtf_empfoto.setText(rs.getString("foto"));
                    //this.jtf_email.setText(rs.getString("email"));
                    this.jcmbx_departamento.addItem(rs.getString("id_depart")+":"+rs.getString("descri_depa"));
                    this.jcmbx_puesto.addItem(rs.getString("id_puesto")+":"+rs.getString("descri_puesto"));
                    this.jcmbx_empjefeinme.addItem(rs.getString("id_jefeinme")+":no disponible");
                    this.jcmbx_clasificacion.addItem(rs.getString("id_clasif")+":"+rs.getString("descri_clasif"));
                    this.jcmbx_status.addItem(rs.getString("id_status")+":"+rs.getString("descri_status"));
                    this.jcmbx_razonbaja.addItem(rs.getString("id_causabaja")+":"+rs.getString("descri_baja"));
                    if(rs.getInt("id_sexo")==1)
                            {
                                this.buttonGroup1.setSelected(jrbtn_sexomasculino.getModel(), true);
                                sexo=1;
                            }
                    if(rs.getInt("id_sexo")==2)
                            {
                                this.buttonGroup1.setSelected(jrbtn_sexofemenino.getModel(), true);
                                sexo=2;
                            }
                    this.jtf_sieuno.setText(rs.getString("id_sieuno"));
                    this.jep_fotoempleado.setText("<html><head></head><body><p style=\"margin-top: 0\"><img src=\"http://"+si_variables.getHostfotos()+"/javaweb/rhfotos/"+rs.getString("foto")+".JPG"+"\" width=\"260\" height=\"210\" border=\"0\" alt=\"Foto\"></img></p></body></html>");

                    if (rs.getString("fecha_alta")!= null)
                        {
                            try
                                {
                                    fechaestaeuropa = formateador.parse(rs.getString("fecha_alta"));
                                    this.jdc_fechaingreso.setDate(fechaestaeuropa);
                                }
                            catch (ParseException e)
                                {
                                //Error, la cadena de texto no se puede convertir en fecha.
                                }
                            this.jlbl_diasemingreso.setText(this.DiaSemana(rs.getString("fecha_alta")));
                        }
                     if (rs.getString("fecha_nac")!= null)
                        {
                            try
                                {
                                    fechaestaeuropa = formateador.parse(rs.getString("fecha_nac"));
                                    this.jdc_fechanaci.setDate(fechaestaeuropa);
                                }
                            catch (ParseException e)
                                {
                                //Error, la cadena de texto no se puede convertir en fecha.
                                }
                        }
                    if (rs.getString("fecha_baja")!= null)
                        {
                            try
                                {
                                    fechaestaeuropa = formateador.parse(rs.getString("fecha_baja"));
                                    this.jdc_fechabaja.setDate(fechaestaeuropa);
                                }
                            catch (ParseException e)
                                {
                                //Error, la cadena de texto no se puede convertir en fecha.
                                }

                        }
                      this.jtf_asist_horaent_pro.setText(rs.getString("horae").substring(0,5)+"");
                    this.jftf_asist_salidaprog.setText(rs.getString("horas").substring(0,5)+"");
                      this.jtf_asist_horaen_dcom.setText(rs.getString("hora2e").substring(0,5)+"");
                    this.jtf_asist_horasa_dcom.setText(rs.getString("hora2s").substring(0,5)+"");
                    this.jtf_minutoscomida.setText(rs.getString("mincom"));
                    switch (rs.getInt("diades")) {
            case 0:
                        this.jcmbx_ope_diadescanso.addItem("0"+":"+"DOMINGO");
                break;
            case 1:
                   this.jcmbx_ope_diadescanso.addItem("1"+":"+"LUNES");
                break;
            case 2:
                this.jcmbx_ope_diadescanso.addItem("2"+":"+"MARTES");
                break;
            case 3:
              this.jcmbx_ope_diadescanso.addItem("3"+":"+"MIERCOLES");
                break;
            case 4:
                   this.jcmbx_ope_diadescanso.addItem("4"+":"+"JUEVES");
                break;
            case 5:
                 this.jcmbx_ope_diadescanso.addItem("5"+":"+"VIERNES");
                break;
            case 6:
                 this.jcmbx_ope_diadescanso.addItem("6"+":"+"SABADO");
                break;
                case 7:
                 this.jcmbx_ope_diadescanso.addItem("7"+":"+"DESC. A PROGRAMAR");
                break;

        }
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
      }

private void dioclickpodind(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
         //System.out.println("dio doble  click");
          int filaalmacenes = jt_nomina_peryded.getSelectedRow(),salus=0;

          this.jtf_idpod.setText(jtable_modelo_nominaperodeduc.getValueAt(filaalmacenes, 0).toString());
          this.jtf_idpoddescripcion.setText(jtable_modelo_nominaperodeduc.getValueAt(filaalmacenes, 1).toString());

          this.jtf_idpodfactor.setText(jtable_modelo_nominaperodeduc.getValueAt(filaalmacenes, 3).toString());
          salus=Integer.valueOf(jtable_modelo_nominaperodeduc.getValueAt(filaalmacenes, 7).toString());
           switch (salus)
                                                    {
                                                        case 1:
                                                           this.jtf_idpodsalario.setText(this.jtf_sueldobase1.getText());
                                                           this.jtf_idpodsalarioreal.setText(this.jtf_sueldobase1.getText());
                                                        break;
                                                        case 2:
                                                           this.jtf_idpodsalario.setText(this.jtf_sueldobase2.getText());
                                                           this.jtf_idpodsalarioreal.setText(this.jtf_sueldobase2.getText());
                                                        break;
                                                        case 3:
                                                           this.jtf_idpodsalario.setText(this.jtf_sueldobase3.getText());
                                                           this.jtf_idpodsalarioreal.setText(this.jtf_sueldobase3.getText());
                                                        break;
                                                        case 4:
                                                           this.jtf_idpodsalario.setText(this.jtf_sueldobase4.getText());
                                                           this.jtf_idpodsalarioreal.setText(this.jtf_sueldobase4.getText());
                                                        break;
                                                         case 5:
                                                           this.jtf_idpodsalario.setText(this.jtf_sueldobase5.getText());
                                                           this.jtf_idpodsalarioreal.setText(this.jtf_sueldobase5.getText());
                                                        break;
                                                    }

        //setVisible(false);
    }

private void carga_datos_internoperoded()
   {
     String texto="select * from x1_supervision_empleados_p_nomina_percepodeduc(3,'1','','') as (id smallint,descrip text,tipopod smallint,valor numeric,obs text,idperodpreno smallint,idtipfonof smallint,salusa smallint,basedt boolean,pagoe boolean);";
     System.out.println(texto);
        try
            {
              rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
               while (rs.next())
                    {
                      //jtable_modelo_detallenomina.addColumn("<html><b>"+rs.getString("id")+":"+rs.getString("descrip")+":"+rs.getString("tipopod")+":"+rs.getString("valor")+":"+rs.getString("idperodpreno")+"</b></html>");
                      jtable_modelo_nominaperodeduc.addRow(new Object[]{rs.getString("id"),rs.getString("descrip"),rs.getString("tipopod"),rs.getString("valor"),rs.getString("obs"),rs.getString("idperodpreno"),rs.getString("idtipfonof"),rs.getString("salusa"),rs.getString("basedt")+":"+rs.getString("pagoe")});

                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
}
private void carga_datos_podempleado()
   {
     String texto="select * from x1_supervision_empleados_peroded_catalogo(1,'"+this.jtf_empid.getText()+"','','') as (id integer,idpod smallint,cantidad numeric,factor numeric,salario numeric,idemp integer,descrip text,tipopod smallint,orden smallint);";
     System.out.println(texto);
        try
            {
              rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
               while (rs.next())
                    {
                      //jtable_modelo_detallenomina.addColumn("<html><b>"+rs.getString("id")+":"+rs.getString("descrip")+":"+rs.getString("tipopod")+":"+rs.getString("valor")+":"+rs.getString("idperodpreno")+"</b></html>");
                      jtable_modelo_nominaperodeducem.addRow(new Object[]{rs.getString("id"),rs.getString("idpod"),rs.getString("descrip"),rs.getString("cantidad"),rs.getString("factor"),rs.getString("salario"),""});

                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
}

private void sieuno_actualizatienda(String idtie,String idempleado)
    {
       //invoco al metodo que trae el recordset de datos
    int actualizado=0;
    rs = x.sieuno_executediversosv2("select * from x1sieuno_empleado_update_tienda("+idempleado+","+idtie+");",si_variables.getconexiongral());
        try
         {
            while (rs.next())
                {
                     actualizado=rs.getInt(1);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
       if (actualizado==1)
            {
               JOptionPane.showMessageDialog(null,"Gracias!", "Sistema Integral(Inventarios: Alta) : Ayuda",1);
            }
       else
            {
               JOptionPane.showMessageDialog(null,"Error tienda no Actualizada!", "Sistema Integral(Empleado: Actualizado) : Ayuda",1);
            }
     }
private void carga_datos_idsieuno(String codigo)
    {
       //invoco al metodo que trae el recordset de datos
    int encontro=0;
    String realiza="",idrealiza="";
       rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_buscaidsieuno('"+codigo+"') as (id integer,nom text,pat text);",si_variables.getconexiongral());
        try
         {
            while (rs.next())
                {
                    encontro=1;
                    idrealiza=rs.getString("id");
                    realiza=rs.getString("nom")+" "+rs.getString("pat");
                }

        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
       if (encontro==1)
              {
                this.jtf_sieuno.setText(idrealiza);
                  if(JOptionPane.showConfirmDialog(null, "Realiza:"+realiza+" desea actualizar?")==0)
                        {
                             rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_actualiza_idsieuno("+this.jtf_empid.getText().trim()+","+this.jtf_sieuno.getText().trim()+");",si_variables.getconexiongral());
                                try
                                    {
                                    while (rs.next())
                                        {

                                        }

                                    }
                                catch(Exception e)
                                    {
                                            System.out.println(e.getMessage());
                                    }
                                            encontro=0;
                        }
                  else
                        {

                            encontro=0;
                        }
              }
       else
           {

               JOptionPane.showMessageDialog(null,"Error No existe el Empleado", "Sistema Integral(Inventarios: Alta) : Ayuda",1);
               encontro=0;
           }
      }
private void carga_datos_idbuscasieuno(String codigo)
    {
       //invoco al metodo que trae el recordset de datos
    int encontro=0;
    String realiza="",idrealiza="";
       rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_buscaidsieuno('"+codigo+"') as (id integer,nom text,pat text);",si_variables.getconexiongral());
        try
         {
            while (rs.next())
                {
                    encontro=1;
                    idrealiza=rs.getString("id");
                    realiza=rs.getString("nom")+" "+rs.getString("pat");
                }

        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
       if (encontro==1)
            {
                   JOptionPane.showMessageDialog(null,"Identificacion ya existe:"+idrealiza+" "+realiza,"Verifica Identificacion : Ayuda",1);
            }
       else
            {
                   JOptionPane.showMessageDialog(null,"Correcto codigo Disponible", "Verifica Identificacion : Ayuda",1);
            }
      }
private void carga_datos_asistencia(int opcion,String busca1,String busca2,String busca3)
    {
    //invoco al metodo que trae el recordset de datos
    int encontro=0,minutos=0;
       DecimalFormat myFormat2 = new DecimalFormat("############");
    String abrehtml="",cierrahtml="",tiempo[]=null,texto="select * from x1_supervision_empleados_asistencia_catalogo("+opcion+",'"+busca1+"','"+busca2+"','"+busca3+"') as (id integer,fechaasiste date,idempleado integer,horaentrada time,horasalida time,idstatus smallint,observaciones text,iddepartamento smallint,idstatusconfirma smallint,nombreempleado character varying(50),nombrepat character varying(50),nombremat character varying(50),statusdescribe text,describedepa character varying(80),statusconfirmacion text,horastrab interval,mincomida interval,idpuntual smallint,despun text,hep time,hsp time,hecp time,hscp time,mincomp smallint);";
    while(jtable_modelo_asistenciaxdia.getRowCount()>0)jtable_modelo_asistenciaxdia.removeRow(0);
    Object[] fnewRow = new Object[10];
    System.out.println(texto);
    try
        {
         rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                      switch (rs.getInt("idstatus"))
                        {

                            case 0:
                                abrehtml="<html><b><font color=#CC0000>";
                                cierrahtml="<font></b></html>";
                            break;
                            case 3:
                                abrehtml="<html><b><font color=#0000FF>";
                                cierrahtml="<font></b></html>";
                            break;
                            case 6:
                                abrehtml="<html><b><font color=#238E23>";
                                cierrahtml="<font></b></html>";
                            break;

                            default:
                                 abrehtml="<html>";
                                 cierrahtml="</html>";
                            break;
                        }
                    fnewRow[0]=abrehtml+this.fechaeuropea(rs.getString("fechaasiste"))+this.DiaSemana(this.fechaeuropea(rs.getString("fechaasiste")))+cierrahtml;
                    //fnewRow[1]=rs.getString("nombreempleado")+" "+rs.getString("nombrepat");
                    fnewRow[1]=abrehtml+rs.getString("idstatus")+":"+rs.getString("statusdescribe")+cierrahtml;
                    fnewRow[2]=abrehtml+rs.getString("horaentrada").substring(0,5)+"("+rs.getString("hep").substring(0,5)+")"+cierrahtml;
                    fnewRow[3]=abrehtml+rs.getString("horasalida").substring(0,5)+cierrahtml;
                      if((rs.getString("horastrab")!=null)&&(!rs.getString("horasalida").substring(0, 5).equals("00:00")))
                    {
                        tiempo=rs.getString("mincomida").split(":");
                        minutos=(Integer.valueOf(tiempo[0])*60)+(Integer.valueOf(tiempo[1]));
                        fnewRow[4]=abrehtml+myFormat2.format(minutos)+"("+rs.getString("mincomp")+")"+cierrahtml;
                        fnewRow[5]=abrehtml+rs.getString("horastrab").substring(0,5)+cierrahtml;
                    }
                    else
                    {
                         fnewRow[4]="";
                        fnewRow[5]="";
                    }
                    fnewRow[6]=abrehtml+rs.getString("observaciones")+cierrahtml;
                    fnewRow[7]=abrehtml+rs.getString("idstatusconfirma")+":"+rs.getString("statusconfirmacion")+cierrahtml;
                    fnewRow[8]=abrehtml+rs.getString("id")+cierrahtml;
                    fnewRow[9]=abrehtml+rs.getString("despun")+cierrahtml;

                    jtable_modelo_asistenciaxdia.addRow(fnewRow);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
      }

private void carga_datos_asistencia_detalle(int opcion,String busca1,String busca2,String busca3)
    {
    //invoco al metodo que trae el recordset de datos
    int encontro=0;
    String realiza="",idrealiza="",texto="";
    while(jtable_modelo_asistenciaxdia_detalle.getRowCount()>0)jtable_modelo_asistenciaxdia_detalle.removeRow(0);
     Object[] fnewRow = new Object[5];
     texto="select * from x1_supervision_empleados_asistencia_catalogo("+opcion+",'"+busca1+"','"+busca2+"','"+busca3+"') as (id integer,fechaasiste date,idempleado integer,horaentrada time,horasalida time,idstatus smallint,observaciones text,iddepartamento smallint,statusdescribe text,describedepa character varying(80));";
     System.out.println(texto);
    try
        {
         rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                    fnewRow[0]="<html><p align=justify>"+this.fechaeuropea(rs.getString("fechaasiste"))+this.DiaSemana(this.fechaeuropea(rs.getString("fechaasiste")))+"</p></html>";
                    //fnewRow[1]=rs.getString("nombreempleado")+" "+rs.getString("nombrepat");
                    fnewRow[1]=rs.getString("idstatus")+":"+rs.getString("statusdescribe");
                    fnewRow[2]=rs.getString("horaentrada").substring(0,5);
                    fnewRow[3]=rs.getString("horasalida").substring(0,5);
                     if(rs.getString("observaciones")!=null)
                        {
                            fnewRow[4]=rs.getString("observaciones");
                        }
                    else
                        {
                            fnewRow[4]="";
                        }
                   jtable_modelo_asistenciaxdia_detalle.addRow(fnewRow);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
      }

private void jt_catpreguntasMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
    }

private void dioclickhisto(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
         System.out.println("dio doble  click historicos");
                int fila = jt_catempleadoshisto.getSelectedRow();
                String idcadena[]=this.jt_catempleadoshisto.getValueAt(fila, 0).toString().split(":");
                String idcadenaemp[]=this.jt_catempleadoshisto.getValueAt(fila, 2).toString().split(":");
                String iddocto[]=this.jt_catempleadoshisto.getValueAt(fila, 3).toString().split(":");
               //this.carga_datos_preguntas(Integer.valueOf(idcadena[0]));

                this.carga_datos_catdetpregunta(Integer.valueOf(idcadenaemp[0]));
                this.carga_datos_catrespuestaxarea(0,iddocto[0],idcadena[0]);


               //fempleadoactual=Integer.valueOf(idcadenaemp[0]);
               //fpuestoactual=Integer.valueOf(idcadena[0]);
               //this.jt_catpreguntas.requestFocus();
               //this.carga_datos_detalleinve(ftienda, ffoliopadre,1,idcadena);

    }

private void dioclick(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
         System.out.println("dio doble  click");
               int fila = jt_catpreguntas.getSelectedRow();
               String idcadena=this.jt_catpreguntas.getValueAt(fila, 0).toString();
             //  this.carga_datos_respuesta(Integer.valueOf(idcadena));
             // fpreguntaactual=fila;
             // this.jt_catrespuestas.requestFocus();
             //this.carga_datos_detalleinve(ftienda, ffoliopadre,1,idcadena);
    }
private void dioclickasistedeta(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
         System.out.println("dio doble  click");
            int fila = jt_historialasistencia.getSelectedRow();
            String idcadena=this.jt_historialasistencia.getValueAt(fila, 0).toString().replace("<html><b><font color=#CC0000>", "").replace("<font></b></html>", "").replace("<html><b><font color=#238E23>", "").replace("<html><b><font color=#0000FF>", "").replace("<html>", "").replace("</html>", "");
            this.jftf_asist_horaentrada.setText(this.jt_historialasistencia.getValueAt(fila, 2).toString().replace("<html><b><font color=#CC0000>", "").replace("<font></b></html>", "").replace("<html><b><font color=#238E23>", "").replace("<html><b><font color=#0000FF>", "").replace("<html>", "").replace("</html>", "")+":00");
            this.jftf_asist_horasalida.setText(this.jt_historialasistencia.getValueAt(fila, 3).toString().replace("<html><b><font color=#CC0000>", "").replace("<font></b></html>", "").replace("<html><b><font color=#238E23>", "").replace("<html><b><font color=#0000FF>", "").replace("<html>", "").replace("</html>", "")+":00");
            this.jcmbx_asist_status.removeAllItems();
            this.jcmbx_asist_status.addItem(this.jt_historialasistencia.getValueAt(fila, 1).toString().replace("<html><b><font color=#CC0000>", "").replace("<font></b></html>", "").replace("<html><b><font color=#238E23>", "").replace("<html><b><font color=#0000FF>", "").replace("<html>", "").replace("</html>", ""));
            this.loadcomboasist_status();
            this.jep_asist_boservaciones.setText(this.jt_historialasistencia.getValueAt(fila, 4).toString().replace("<html><b><font color=#CC0000>", "").replace("<font></b></html>", "").replace("<html><b><font color=#238E23>", "").replace("<html><b><font color=#0000FF>", "").replace("<html>", "").replace("</html>", ""));
            this.jftf_asist_id.setText(this.jt_historialasistencia.getValueAt(fila, 6).toString().replace("<html><b><font color=#CC0000>", "").replace("<font></b></html>", "").replace("<html><b><font color=#238E23>", "").replace("<html><b><font color=#0000FF>", "").replace("<html>", "").replace("</html>", ""));
            this.jtf_asis_fechaasis.setText(idcadena.substring(0, 10));
            this.carga_datos_asistencia_detalle(3, this.jtf_empid.getText(), this.fechaamericana(idcadena.substring(0, 10)), "");
            this.jcmbx_asist_status.requestFocus();
    }


private void jt_empleadocxcMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
    }
private void dioclickabonar(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
         int fila = jt_empleadocxc.getSelectedRow();
         this.jtf_documentocxc.setText(this.jt_empleadocxc.getValueAt(fila, 2).toString());
         this.jbtn_guardarcxcmovi.setVisible(true);
         this.carga_datos_empleadocxcdetalle(0,this.jt_empleadocxc.getValueAt(fila, 2).toString());
    }

private void agregardoctocxc_detalle(int folio,int empleado,String factura,float cantidad,String observacodigo,String idconcepto)
    {
       //invoco al metodo que trae el recordset de datos
    int encontrado=0;

        try
         {
            rs = x.sieuno_executediversosv2("select * from x1_supervision_insumos_doctocxc_insert_movimientos("+folio+","+empleado+",'"+factura+"',"+cantidad+",'"+observacodigo+"',"+idconcepto+");",si_variables.getconexiongral());
            while (rs.next())
                {
                       encontrado=rs.getInt(1);
                }
         }
        catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
       if (encontrado==1)
              {

                    JOptionPane.showMessageDialog(null,"Gracias Registro Correcto!", "Sistema Integral(CxC Aplicando Movimientos) : Ayuda",1);
                    this.jbtn_guardarcxcmovi.setVisible(false);
                    this.jcmbx_concepto.setSelectedIndex(0);
                    this.jtf_documentocxc.setText("");
                    this.jtf_importe.setText("");
                    this.jtf_boservacionescxc.setText("");
              }
       else
              {
               //JOptionPane.showMessageDialog(null,"Error Clave:"+codigoenvia+" No existe!", "Sistema Integral(Inventarios: Alta) : Ayuda",1);
              }
    }
private void guarda_empleado()
    {
        SimpleDateFormat formato = new SimpleDateFormat("yyyy-MM-dd");
        String pFechain = formato.format(this.jdc_fechaingreso.getDate());//fecha final de reporte

        String pFechana = formato.format(this.jdc_fechanaci.getDate());//fecha final de reporte

        String arreglo_depa[]=this.jcmbx_departamento.getSelectedItem().toString().split(":");
        int depa=Integer.valueOf(arreglo_depa[0]);

        String arreglo_puesto[]=this.jcmbx_puesto.getSelectedItem().toString().split(":");
        int puesto=Integer.valueOf(arreglo_puesto[0]);

        String arreglo_jefeinme[]=this.jcmbx_empjefeinme.getSelectedItem().toString().split(":");
        int jefeinme=Integer.valueOf(arreglo_jefeinme[0]);

        String arreglo_status[]=this.jcmbx_status.getSelectedItem().toString().split(":");
        int status=Integer.valueOf(arreglo_status[0]);

        String arreglo_razon[]=this.jcmbx_razonbaja.getSelectedItem().toString().split(":");
        int razon=Integer.valueOf(arreglo_razon[0]);

        String arreglo_clasif[]=this.jcmbx_clasificacion.getSelectedItem().toString().split(":");
        int clasif=Integer.valueOf(arreglo_clasif[0]);

        String arreglo_estadocivil[]=this.jcmbx_stadocivil.getSelectedItem().toString().split(":");
        int stadocivil=Integer.valueOf(arreglo_estadocivil[0]);

        String diades[]=this.jcmbx_ope_diadescanso.getSelectedItem().toString().split(":");

       String texto="select * from x1_supervision_empleados_actualiza_generalv2(1,"+Integer.valueOf(this.jtf_empid.getText().toString())+",'"+this.jtf_empnombre.getText().toUpperCase().trim()+"','"+this.jtf_empapat.getText().toUpperCase().trim()+"','"+this.jtf_empamat.getText().toUpperCase().trim()+"','"+this.jtf_domcalle.getText().toUpperCase().trim()+"','"+this.jtf_domcolonia.getText().toUpperCase().trim()+"','"+this.jtf_dompobla.getText().toUpperCase().trim()+"','"+this.jtf_domcod.getText().toUpperCase().trim()+"','"+this.jtf_codigoidentifica.getText().trim()+"',"+depa+","+puesto+","+status+",'"+this.jtf_empfoto.getText().toUpperCase().trim()+"',"+razon+","+clasif+","+sexo+","+stadocivil+",'"+this.jtf_domtelefono.getText().toUpperCase().trim()+"','"+this.jtf_email.getText().trim()+"','"+pFechain+"','"+pFechana+"','"+this.jtf_asist_horaent_pro.getText()+":00"+"','"+this.jftf_asist_salidaprog.getText()+":00"+"','"+this.jtf_asist_horaen_dcom.getText()+":00"+"','"+this.jtf_asist_horasa_dcom.getText()+":00"+"','"+this.jtf_minutoscomida.getText()+"','"+diades[0]+"')";
       System.out.println(texto);

       String confirma="";
        try
         {
            rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                     confirma=rs.getString(1);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
       if (confirma.equals("1"))
              {
                JOptionPane.showMessageDialog(null,"Gracias datos Actualizados Correctamente", "Sistema Integral Indicador",1);
              }
         else
              {
                JOptionPane.showMessageDialog(null,"Error Consulte con Su Administrador", "Sistema Integral Indicadores",1);
              }
      }
private void guarda_empleado_baja()
    {
        SimpleDateFormat formato = new SimpleDateFormat("yyyy-MM-dd");
        String pFechabaja = formato.format(this.jdc_fechabaja.getDate());//fecha final de reporte

        String arreglo_razon[]=this.jcmbx_razonbaja.getSelectedItem().toString().split(":");
        int razon=Integer.valueOf(arreglo_razon[0]);


       String texto="select * from x1_supervision_empleados_actualiza_generalv2(2,"+Integer.valueOf(this.jtf_empid.getText().toString())+",'','','','','','','','',0,0,0,'',"+razon+",0,0,0,'','','"+pFechabaja+"','')";
       System.out.println(texto);

       String confirma="";
        try
         {
              rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                     confirma=rs.getString(1);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
       if (confirma.equals("1"))
              {
                JOptionPane.showMessageDialog(null,"Gracias datos Actualizados Correctamente", "Sistema Integral Indicador",1);
              }
         else
              {
                JOptionPane.showMessageDialog(null,"Error Consulte con Su Administrador", "Sistema Integral Indicadores",1);
              }
      }

private void loadcombodepa(){
            try
            {
                  rs = x.sieuno_executediversosv2("select * from x1_supervision_tareas_departamentos() as (id smallint,descrip character varying(80));",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_departamento.addItem(rs.getString("id")+":"+rs.getString("descrip"));
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }
private void loadcombostatus(){


            try
            {
          rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_status() as (id smallint,descrip character varying(25));",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_status.addItem(rs.getString("id")+":"+rs.getString("descrip"));


                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }

private void loadcombopuestos(){


            try
            {
          rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_puestos() as (id smallint,descrip text);",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_puesto.addItem(rs.getString("id")+":"+rs.getString("descrip"));


                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }
private void loadcombotiposcausabaja(){


            try
            {
          rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_tipocausabaja() as (id smallint,descrip character varying(25));",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_razonbaja.addItem(rs.getString("id")+":"+rs.getString("descrip"));


                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }

private void loadcomboestadocivil(){


            try
            {
          rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_estadocivil() as (id smallint,descrip character varying(25));",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_stadocivil.addItem(rs.getString("id")+":"+rs.getString("descrip"));
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }


 private void loadcombo_tiendas(){
           this.jcbx_tiendas.addItem("0:Elige Tienda");
          /* try
            {
            rs = x.sieuno_executediversosv2("select * from x1venta_tiendasmichelle() as (descripcion character varying(35),idsieuno integer);",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcbx_tiendas.addItem(rs.getString("idsieuno")+":"+rs.getString("descripcion"));
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }*/
    }

private void loadcomboconceptoscxc(){
this.jcmbx_concepto.addItem("0:Elegir Concepto");

            try
            {
                  rs = x.sieuno_executediversosv2("select * from x1_supervision_cxc_conceptos() as (id smallint,descripconcep character varying(40),tipoconcepto character varying(3),observacion character varying(50));",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_concepto.addItem(rs.getString("id")+":"+rs.getString("descripconcep"));
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }
private void loadcomboasist_status(){


            try
            {
                rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_asistencia_status() as (id smallint,descrip text,observacion text);",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_asist_status.addItem(rs.getString("id")+":"+rs.getString("descrip")+"("+rs.getString("observacion")+")");
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }

private void loadcombo_razsocpatron(){

           try
            {
            rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_patron(1,'','','','') as (idraz smallint,nombre character varying(60));",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_idrazonsocial.addItem(rs.getString("idraz")+":"+rs.getString("nombre"));
                      this.jcmbx_idrazonsocialnof.addItem(rs.getString("idraz")+":"+rs.getString("nombre"));

                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }

private void loadcombo_diadescanso()
 {

            this.jcmbx_ope_diadescanso.addItem("8"+":"+"No Asignado");
            this.jcmbx_ope_diadescanso.addItem("0"+":"+"DOMINGO");
            this.jcmbx_ope_diadescanso.addItem("1"+":"+"LUNES");
            this.jcmbx_ope_diadescanso.addItem("2"+":"+"MARTES");
            this.jcmbx_ope_diadescanso.addItem("3"+":"+"MIERCOLES");
            this.jcmbx_ope_diadescanso.addItem("4"+":"+"JUEVES");
            this.jcmbx_ope_diadescanso.addItem("5"+":"+"VIERNES");
            this.jcmbx_ope_diadescanso.addItem("6"+":"+"SABADO");

    }


private void loadcombo_razsocpatron_clasif(){
           try
            {
            rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_patron(10,'','','','') as (idcla smallint,nombrec text,idpat smallint);",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_idrazonclasif.addItem(rs.getString("idcla")+":"+rs.getString("nombrec"));
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }

private void loadcombo_esquema()
    {
           try
            {
            rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_esquema_cat(1,'','','','') as (id smallint,descrip text,idstatus smallint);",si_variables.getconexiongral());
               while (rs.next())
                    {
                      this.jcmbx_idesquema.addItem(rs.getString("id")+":"+rs.getString("descrip"));
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
    }

private void carga_datos_catempleadoshistorial(String textobusca)
{
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
           while(jtable_modelo_empleado_hist.getRowCount()>0)jtable_modelo_empleado_hist.removeRow(0);
       Object[] fnewRow = new Object[6];

        try
         {
       rs = x.sieuno_executediversosv2("select * from x1_supervision_indicadores_aplicados_cathistorico("+textobusca+") as (id integer,iddocto integer,idaplica integer,idempleado integer,observaciones text,idpuesto smallint,fechaalta date,nombreaplica character varying(50),nombre character varying(50),nombreapat character varying(50),totpuntos bigint,puestodesc text,rini date,rfin date);",si_variables.getconexiongral());
            while (rs.next())
                {
                        fnewRow[0]=rs.getString("idempleado")+":"+rs.getString("nombreaplica");
                        fnewRow[1]="<html><p align=justify>"+this.fechaeuropea(rs.getString("fechaalta"))+"<br>"+this.DiaSemana(this.fechaeuropea(rs.getString("fechaalta")))+"</p></html>";
                        fnewRow[2]=rs.getString("id")+":"+rs.getString("nombre")+" "+rs.getString("nombreapat");
                        fnewRow[3]=rs.getString("iddocto")+":"+rs.getString("puestodesc");
                        fnewRow[4]=rs.getString("totpuntos");
                        fnewRow[5]="<html><p align=justify>"+this.fechaeuropea(rs.getString("rini"))+" A "+this.fechaeuropea(rs.getString("rfin"))+"<br>"+this.DiaSemana(this.fechaeuropea(rs.getString("rini")))+" A "+this.DiaSemana(this.fechaeuropea(rs.getString("rfin")))+"</p></html>";
                        jtable_modelo_empleado_hist.addRow(fnewRow);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }


        int numerofilas=this.jtable_modelo_empleado_hist.getRowCount();
        for(int i = 0 ;i < numerofilas; i++)
           {
                jt_catempleadoshisto.setRowHeight(i, 30);
           }
}
private void carga_datos_catdetpregunta(int folio)
{
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
        while(jtable_modelo.getRowCount()>0)jtable_modelo.removeRow(0);
       Object[] fnewRow = new Object[4];

        try
         {
               rs = x.sieuno_executediversosv2("select * from x1_supervision_indicadores_aplicados_detalle("+folio+") as (id integer,iddocto integer,idpre smallint,idresp smallint,observaciones text,idarea smallint,pregdescrip text,respuedescrip text, valor integer);",si_variables.getconexiongral());
            while (rs.next())
                {
                        fnewRow[0]=rs.getString("idarea");
                        fnewRow[1]=rs.getString("pregdescrip");
                        fnewRow[2]=rs.getString("valor")+"="+rs.getString("respuedescrip");
                        fnewRow[3]=rs.getString("observaciones");
                        jtable_modelo.addRow(fnewRow);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }

}
private void carga_datos_catrespuestaxarea(int opcion,String padre,String empleado)
{
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
       DecimalFormat miformat = new DecimalFormat("###,###,###");
       float total=0, totalpuntos=0,totalpuntosmaximo=0,acumporcentajes=0;
       while(jtable_modelo_resxarea.getRowCount()>0)jtable_modelo_resxarea.removeRow(0);
       Object[] fnewRow = new Object[7];

        try
         {
           rs = x.sieuno_executediversosv2("select * from x1_supervision_indicadores_aplicados_valores("+opcion+",'"+padre+"','"+empleado+"') as (id integer, iddocto integer,idempleado integer,idpuesto smallint,idvalortot bigint,idarea smallint,descriparea text,pesoarea numeric,areaobserva text,puntosmaximos numeric);",si_variables.getconexiongral());
            while (rs.next())
                {
                        fnewRow[0]=rs.getString("descriparea")+"(Max="+rs.getString("puntosmaximos")+")";
                        fnewRow[1]=rs.getString("idvalortot");
                        fnewRow[2]=miformat.format((rs.getFloat("idvalortot")/rs.getFloat("puntosmaximos"))*100)+"%";
                        total=rs.getFloat("idvalortot")/rs.getFloat("puntosmaximos");
                        fnewRow[3]=rs.getString("pesoarea")+"%";
                        fnewRow[4]=miformat.format(((total/100)*rs.getFloat("pesoarea"))*100)+"%";
                        fnewRow[5]="";
                        fnewRow[6]="";
                        totalpuntos+=rs.getFloat("idvalortot");
                        totalpuntosmaximo+=rs.getFloat("puntosmaximos");
                        acumporcentajes+=((total/100)*rs.getFloat("pesoarea"))*100;
                        jtable_modelo_resxarea.addRow(fnewRow);

                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
      fnewRow[0]="TOTALES:(Maximo="+totalpuntosmaximo+")";
      fnewRow[1]=miformat.format(totalpuntos)+"";
      fnewRow[2]=miformat.format((totalpuntos/totalpuntosmaximo)*100)+"%";
      fnewRow[3]="";
      fnewRow[4]=miformat.format(acumporcentajes)+"%";
      fnewRow[5]="";
      fnewRow[6]="";

     int numerofilas=this.jtable_modelo_resxarea.getRowCount();

             for(int i = 0 ;i < numerofilas; i++)
                {
                     jtable_modelo_resxarea.setValueAt(miformat.format(acumporcentajes)+"%", i,5);
                     jtable_modelo_resxarea.setValueAt("85%", i,6);
                }

      jtable_modelo_resxarea.addRow(fnewRow);
}


private void carga_datos_ventaxmes(int idempleado)
{
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
       while(jtable_modelo_empleado_ventasxmes.getRowCount()>0)jtable_modelo_empleado_ventasxmes.removeRow(0);
       Object[] fnewRow = new Object[5];
        DecimalFormat miformat = new DecimalFormat("###,###,###,###");

        try
         {
        rs = x.sieuno_executediversosv2("select * from x1venta_agente_estadisticaxmes("+idempleado+") as (fecha date,fe text,agente integer,ventaxmes double precision,notas numeric);",si_variables.getconexiongral());
            while (rs.next())
                {
                        fnewRow[0]=rs.getString("agente")+":"+this.jtf_empnombre.getText()+" "+this.jtf_empamat.getText();
                        fnewRow[1]=rs.getString("fe");
                         fnewRow[2]=miformat.format(rs.getFloat("notas"));
                        fnewRow[3]=miformat.format(rs.getFloat("ventaxmes"));

                        fnewRow[4]=miformat.format(rs.getFloat("ventaxmes")/rs.getFloat("notas"));
                        jtable_modelo_empleado_ventasxmes.addRow(fnewRow);
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }

}







private String  fechaeuropea(String fecha) {

         //resibe cadena de fecha en formato americano yyyy-MM-dd
        java.util.Date fechaestaeuropa=null;
       SimpleDateFormat formateadorestaeuropa = new SimpleDateFormat("dd-MM-yyyy");
       String cadenafecha="";
        try
         {
          fechaestaeuropa = formateadoresta.parse(fecha);
         }
        catch (ParseException e)
          {
             //Error, la cadena de texto no se puede convertir en fecha.
          }
       cadenafecha= formateadorestaeuropa.format(fechaestaeuropa);
       return cadenafecha;

    }
private String  fechaeuropea(Date fecha) {
       SimpleDateFormat formateadorestaeuropa = new SimpleDateFormat("dd-MM-yyyy");
       String cadenafecha="";

       cadenafecha= formateadorestaeuropa.format(fecha);
       return cadenafecha;

    }
private String DiaSemana(String fe) {
         String dia = "";
       java.util.Date fecha=null;
         try
            {
             fecha = formateador.parse(fe);

           }
        catch (ParseException e)
            {
            //Error, la cadena de texto no se puede convertir en fecha.
            }
        Calendar cal= Calendar.getInstance();
        cal.setTime(fecha);
        //ojo para establecer o recetear cada parte de la fecha por separado
        //cal.set(Calendar.YEAR, fecha.getYear());
        //cal.set(Calendar.MONTH, fecha.getMonth());
        //cal.set(Calendar.DAY_OF_MONTH, fecha.getDay());
        int diaInt = cal.get(Calendar.DAY_OF_WEEK);
        switch (diaInt) {
            case 1:
                dia = "Domingo";
                break;
            case 2:
                dia = "Lunes";
                break;
            case 3:
                dia = "Martes";
                break;
            case 4:
                dia = "Miercoles";
                break;
            case 5:
                dia = "Jueves";
                break;
            case 6:
                dia = "Viernes";
                break;
            case 7:
                dia = "Sabado";
                break;

        }
        return dia;
    }
private String fechaamericana(Date fe) {
       SimpleDateFormat formateadorestaeuropa = new SimpleDateFormat("yyyy-MM-dd");
       String cadenafecha="";
       cadenafecha= formateadorestaeuropa.format(fe);
       return cadenafecha;

    }

private String  fechaamericana(String fecha) {

         //resibe cadena de fecha en formato americano dd-MM-yyyy
        java.util.Date fechaestaeuropa=null;
       SimpleDateFormat formateadorestaamericano = new SimpleDateFormat("yyyy-MM-dd");
       String cadenafecha="";
        try
         {
          fechaestaeuropa = formateador.parse(fecha);
         }
        catch (ParseException e)
          {
             //Error, la cadena de texto no se puede convertir en fecha.
          }
       cadenafecha= formateadorestaamericano.format(fechaestaeuropa);
       return cadenafecha;

    }

private void carga_datos_expediente(String textobusca)
{
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento


       rs = x.sieuno_executediversosv2("select * from x1_supervision_empleados_verexpediente("+textobusca+") as (observacion text);",si_variables.getconexiongral());
        try
         {
            while (rs.next())
                {
                      this.jep_expediente.setText("<p align=justify>"+rs.getString("observacion")+"</p>");
                }
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }

}

private void asistencia_actualiza(int opcion,String idasist,String empleado,String observacion,String departamento,String shorae,String shoras,String idstatus,String valorx)
    {
       //invoco al metodo que trae el recordset de datos
    int encontrado=0;
    String texto="select * from x1_supervision_empleados_asistenciamaestro_update("+opcion+","+idasist+","+empleado+",'"+observacion+"',"+departamento+",'"+shorae+"','"+shoras+"','"+idstatus+"','"+valorx+"');";
    System.out.println(texto);
        try
         {
            rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                       encontrado=rs.getInt(1);
                }
         }
        catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
       if (encontrado==1)
              {

                    JOptionPane.showMessageDialog(null,"Gracias Registro Correcto!", "Sistema Integral(Modificando Asistencia) : Ayuda",1);
                    this.carga_datos_asistencia(13, this.jtf_empid.getText(),this.fechaamericana(this.jdc_fechainicial.getDate()),this.fechaamericana(this.jdc_fechafinal.getDate()));

              }
       else
              {
               //JOptionPane.showMessageDialog(null,"Error Clave:"+codigoenvia+" No existe!", "Sistema Integral(Inventarios: Alta) : Ayuda",1);
              }
    }
private void expediente_add(String empleado,String comentario){


         String alias=si_variables.getLogin().substring(0, 4)+":";
        String texto="",confirma="";
        texto="select * from x1_supervision_empleados_actualiza_observacion("+empleado+",'"+alias.toUpperCase()+comentario.toUpperCase()+"<br>"+"');";
        System.out.println(texto);

            try
            {
                rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());

               while (rs.next())
                    {
                      confirma=rs.getString(1);
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
         if (confirma.equals("1"))
              {

                JOptionPane.showMessageDialog(null,"Gracias Anotacion Guardada Correctamente", "Sistema Integral Tareas",1);


              }
         else
              {
                JOptionPane.showMessageDialog(null,"Error Verifiqu con Administrador no se ha podido guardar", "Sistema Integral Error",1);

              }


    }
private void avisos_add(String empleado,String comentario,String fechaaviso){


         String alias=si_variables.getLogin().substring(0, 4)+":";
        String texto="",confirma="";
        texto="select * from x1_supervision_empleados_avisos_insert('"+fechaaviso+"','"+empleado+"','"+comentario+"');";
        System.out.println(texto);

            try
            {
                rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());

               while (rs.next())
                    {
                      confirma=rs.getString(1);
                    }
             }
            catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
         if (confirma.equals("1"))
              {

                JOptionPane.showMessageDialog(null,"Gracias Aviso Guardada Correctamente", "Sistema Integral Tareas",1);


              }
         else
              {
                JOptionPane.showMessageDialog(null,"Error Verifiqu con Administrador no se ha podido guardar", "Sistema Integral Error",1);

              }


    }


private void contruir_grafica_resultados()
    {
        //inicio a extraer los totales del dia sin incluir monedero es decir al reporte detalle corte
        //contruyo el grafico de lineas del cortes del dia detalle

         DefaultCategoryDataset datasetbarra = new DefaultCategoryDataset();
         String titulografico="",totaltiendatexto="";
         int totalfilasreporte=this.jtable_modelo_empleado_hist.getRowCount(),i=0,ii=0;


         for(i=0;i<totalfilasreporte;i++)
         {

                   totaltiendatexto = jtable_modelo_empleado_hist.getValueAt(i, 4).toString();
                    System.out.println(totaltiendatexto);
                    titulografico=jtable_modelo_empleado_hist.getValueAt(i, 1).toString().replace("<html><p align=justify>","").replace("<br>","").replace("</p></html>", "");

                    datasetbarra.addValue(Float.valueOf(totaltiendatexto.replace(",","").replace(".","")),titulografico,"Indicador");

         }

         System.out.println("se crea nuevo:");
       /* graficacion_varios_barras gvbtempo = new graficacion_varios_barras("Sistema Integral: Estadisticas proveedor",datasetbarra,"Resultado Total Indicadores:"+this.jtf_empnombre.getText()+" "+this.jtf_empapat.getText(),"Colaborador");
        gvbtempo.pack();
        RefineryUtilities.centerFrameOnScreen(gvbtempo);
        gvbtempo.setVisible(true);
*/
     }
private void contruir_grafica_ventasxmes()
    {
        //inicio a extraer los totales del dia sin incluir monedero es decir al reporte detalle corte
        //contruyo el grafico de lineas del cortes del dia detalle

         DefaultCategoryDataset datasetbarra = new DefaultCategoryDataset();
         String titulografico="",totaltiendatexto="";
         int totalfilasreporte=this.jtable_modelo_empleado_ventasxmes.getRowCount(),i=0,ii=0;


         for(i=0;i<totalfilasreporte;i++)
         {

                   totaltiendatexto = jtable_modelo_empleado_ventasxmes.getValueAt(i, 3).toString();
                    System.out.println(totaltiendatexto);
                    titulografico=jtable_modelo_empleado_ventasxmes.getValueAt(i, 1).toString().replace("<html><p align=justify>","").replace("<br>","").replace("</p></html>", "");

                    datasetbarra.addValue(Float.valueOf(totaltiendatexto.replace(",","").replace(".","")),titulografico,jtable_modelo_empleado_ventasxmes.getValueAt(i, 0).toString().replace("<html><p align=justify>","").replace("<br>","").replace("</p></html>", ""));

         }

         System.out.println("se crea nuevo:");
/*        graficacion_varios_barras gvbtempo = new graficacion_varios_barras("Sistema Integral: Estadisticas proveedor",datasetbarra,"Resultado Total Indicadores:"+this.jtf_empnombre.getText()+" "+this.jtf_empapat.getText(),"Colaborador");
        gvbtempo.pack();
        RefineryUtilities.centerFrameOnScreen(gvbtempo);
        gvbtempo.setVisible(true);
*/
     }

private void carga_datos_empleadocxc(int opcion,String textobusca)
{
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
        while(this.jtable_modelo_empleadocxc.getRowCount()>0)this.jtable_modelo_empleadocxc.removeRow(0);
       Object[] fnewRow = new Object[7];

        try
         {
            rs = x.sieuno_executediversosv2("select * from x1distribucion_insumos_salidas_saldosdocto_catalogo("+opcion+",'"+textobusca+"') as (idreg integer,iddocto character varying(12),desta character varying(15),fedoc date,obserdoc character varying(80), tpz numeric,totprecio numeric,idconsiga integer,nombreconsigando text,saldo numeric);",si_variables.getconexiongral());
            while (rs.next())
                 {
                        System.out.println("historial cxc");
                        fnewRow[0]=rs.getString("desta");
                        fnewRow[1]=rs.getString("idconsiga")+":"+rs.getString("nombreconsigando");
                        fnewRow[2]=rs.getString("iddocto");
                        fnewRow[3]=this.fechaeuropea(rs.getString("fedoc"));
                        fnewRow[4]=rs.getString("tpz");
                        fnewRow[5]=rs.getString("totprecio");
                        fnewRow[6]=rs.getString("saldo");
                        jtable_modelo_empleadocxc.addRow(fnewRow);
                }
        }
        catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
}



private void carga_datos_empleadocxcdetalle(int opcion,String textobusca)
    {
       //invoco al metodo que trae el recordset de datos
       //voy por el detalle del documento
        DecimalFormat miformat = new DecimalFormat("###,###,###,###");
    while(this.jtable_modelo_empleadocxcdetalle.getRowCount()>0)this.jtable_modelo_empleadocxcdetalle.removeRow(0);

        Object[] fnewRow = new Object[7];
        String abrehtml="",cierrahtml="";
        float importe=0;

        try
         {
            rs = x.sieuno_executediversosv2("select * from x1_supervision_cxc_movimientosvista("+opcion+",'"+textobusca+"') as (folio integer,statusmovi smallint,idcuentagral smallint,idcuentadetalle smallint,idcuentabanca smallint,idconcepto smallint,idclieprov character varying(15),fechaaplica date,fechadocto date,fechavenci date,fechahora date,factura character varying(12),documento character varying(12),documento2 character varying(12),referencia character varying(40),cantidad numeric,idmoneda smallint,factor numeric,cantidadnacional numeric,observacion character varying(80),statusdescrip character varying(15),descripbanco character varying(40),cuenta character varying(25),describeconcepto character varying(40),describemoneda character varying(30),describecuenta character varying(12));",si_variables.getconexiongral());
            while (rs.next())
                 {
                        if(rs.getInt("idconcepto")< 50)
                            {
                                abrehtml="<html><b>";
                                cierrahtml="</b></html>";
                                fnewRow[3]=abrehtml+miformat.format(rs.getFloat("cantidadnacional"))+cierrahtml;
                                fnewRow[4]="";

                            }
                        else
                            {
                                fnewRow[3]="";
                                abrehtml="<html>";
                                cierrahtml="</html>";
                                fnewRow[4]=abrehtml+miformat.format(rs.getFloat("cantidadnacional"))+cierrahtml;
                            }
                        importe+=rs.getFloat("cantidadnacional");
                        System.out.println("historial cxc");
                        fnewRow[0]=abrehtml+rs.getString("folio")+cierrahtml;
                        fnewRow[1]=abrehtml+rs.getString("factura")+cierrahtml;
                        fnewRow[2]=abrehtml+this.fechaeuropea(rs.getString("fechaaplica"))+cierrahtml;
                        fnewRow[5]=abrehtml+miformat.format(importe)+cierrahtml;
                        fnewRow[6]=abrehtml+rs.getString("observacion")+""+cierrahtml;
                        jtable_modelo_empleadocxcdetalle.addRow(fnewRow);
                }
        }
        catch(Exception e)
            {
                System.out.println(e.getMessage());
            }
}

private void carga_datos_salario(String codigo)
    {
       //invoco al metodo que trae el recordset de datos
     java.util.Date fechaestaeuropa=null;
     DecimalFormat miformat = new DecimalFormat("############.#####");
     this.jcmbx_idrazonsocial.removeAllItems();
     this.jcmbx_idrazonsocialnof.removeAllItems();
     int encontro=0;
     String texto="select * from x1_supervision_empleados_catalogo(14,'"+codigo+"','','','') as (id integer,rfc character varying(18),curp character varying(20),imss character varying(20),sueldo1 numeric,sueldo2 numeric,idpat smallint,sueldo3 numeric,sueldo4 numeric,sueldo5 numeric,idpat2 smallint,nombrepa character varying(60),nombrepa2 character varying(60),fechaalta date,fechaimss date,idcla smallint,clasifdes text,idesq smallint,esquemades text);";
     System.out.println(texto);
        try
         {
            rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {

                this.jtf_empleadorfc.setText(rs.getString("rfc"));
                this.jtf_empleadocurp.setText(rs.getString("curp"));
                this.jtf_empleadoimss.setText(rs.getString("imss"));

                   this.jtf_sueldobase1.setText(miformat.format(rs.getFloat("sueldo1")));
                   this.jtf_sueldobase2.setText(miformat.format(rs.getFloat("sueldo2")));
                   this.jtf_sueldobase3.setText(miformat.format(rs.getFloat("sueldo3")));
                   this.jtf_sueldobase4.setText(miformat.format(rs.getFloat("sueldo4")));
                   this.jtf_sueldobase5.setText(miformat.format(rs.getFloat("sueldo5")));

                   this.jcmbx_idrazonsocial.addItem(rs.getString("idpat")+":"+rs.getString("nombrepa"));
                   this.jcmbx_idrazonsocialnof.addItem(rs.getString("idpat2")+":"+rs.getString("nombrepa2"));
                   this.jcmbx_idrazonclasif.addItem(rs.getString("idcla")+":"+rs.getString("clasifdes"));
                   this.jcmbx_idesquema.addItem(rs.getString("idesq")+":"+rs.getString("esquemades"));

                    if (rs.getString("fechaalta")!= null)
                        {
                            try
                                {
                                    fechaestaeuropa = formateador.parse(this.fechaeuropea(rs.getString("fechaalta")));
                                    this.jdc_fechaingreso1.setDate(fechaestaeuropa);
                                }
                            catch (ParseException e)
                                {
                                //Error, la cadena de texto no se puede convertir en fecha.
                                }
                        }
                        if (rs.getString("fechaimss")!= null)
                        {
                            try
                                {
                                    fechaestaeuropa = formateador.parse(this.fechaeuropea(rs.getString("fechaimss")));
                                    this.jdc_fechaingresoimss.setDate(fechaestaeuropa);
                                }
                            catch (ParseException e)
                                {
                                //Error, la cadena de texto no se puede convertir en fecha.
                                }
                        }


                }

        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
        texto="select * from x1_supervision_empleados_catalogo_plazas(21,'"+codigo+"','','','') as (idp smallint,area text,puesto text);";
        try
         {
            rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                   encontro=1;
                   this.jcmbx_idrazonclasif1.addItem(rs.getString("idp")+":"+rs.getString("puesto")+"("+rs.getString("area")+")");
                }

        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
        if(encontro==0)
            {
                this.jcmbx_idesquema.addItem("0:PLAZA NO ASIGNADA");
            }
        texto="select * from x1_supervision_empleados_catalogo_plazas(22,'"+codigo+"','','','') as (idp smallint,area text,puesto text);";
        try
         {
            rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
            while (rs.next())
                {
                   encontro=1;
                   this.jcmbx_idrazonclasif1.addItem(rs.getString("idp")+":"+rs.getString("puesto")+"("+rs.getString("area")+")");
                }

        }
         catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
      }

private int find_idpodemp(String codigo)  {
     int numerofilas=this.jtable_modelo_nominaperodeducem.getRowCount(),ii=00,encontrado=0;
      String columtitulo=null,mesactual="";
      System.out.println("Esto encontro:"+codigo);
       for( ii=0;ii<numerofilas;ii++)
                {
                    mesactual=jtable_modelo_nominaperodeducem.getValueAt(ii, 0).toString();
                    if (mesactual.equals(codigo))
                        {
                            encontrado=1;
                        }
                }
    return encontrado;
}

private void jt_empleadocxcdetalleMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
}
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    @SuppressWarnings("unchecked")
    // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
    private void initComponents() {

        buttonGroup1 = new javax.swing.ButtonGroup();
        jTabbedPane1 = new javax.swing.JTabbedPane();
        jPanel1 = new javax.swing.JPanel();
        jLabel3 = new javax.swing.JLabel();
        jtf_empid = new javax.swing.JTextField();
        jLabel4 = new javax.swing.JLabel();
        jtf_empestatus = new javax.swing.JTextField();
        jLabel5 = new javax.swing.JLabel();
        jtf_empnombre = new javax.swing.JTextField();
        jtf_empapat = new javax.swing.JTextField();
        jLabel6 = new javax.swing.JLabel();
        jLabel7 = new javax.swing.JLabel();
        jtf_empamat = new javax.swing.JTextField();
        jPanel5 = new javax.swing.JPanel();
        jLabel8 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jLabel10 = new javax.swing.JLabel();
        jLabel11 = new javax.swing.JLabel();
        jLabel12 = new javax.swing.JLabel();
        jtf_domcalle = new javax.swing.JTextField();
        jtf_domcolonia = new javax.swing.JTextField();
        jtf_dompobla = new javax.swing.JTextField();
        jtf_domcod = new javax.swing.JTextField();
        jtf_domtelefono = new javax.swing.JTextField();
        jLabel21 = new javax.swing.JLabel();
        jtf_empfoto = new javax.swing.JTextField();
        jLabel23 = new javax.swing.JLabel();
        jtf_email = new javax.swing.JTextField();
        jPanel6 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jep_fotoempleado = new javax.swing.JEditorPane();
        jPanel7 = new javax.swing.JPanel();
        jLabel13 = new javax.swing.JLabel();
        jcmbx_departamento = new javax.swing.JComboBox();
        jLabel14 = new javax.swing.JLabel();
        jcmbx_puesto = new javax.swing.JComboBox();
        jLabel15 = new javax.swing.JLabel();
        jcmbx_clasificacion = new javax.swing.JComboBox();
        jLabel16 = new javax.swing.JLabel();
        jcmbx_empjefeinme = new javax.swing.JComboBox();
        jLabel19 = new javax.swing.JLabel();
        jcmbx_status = new javax.swing.JComboBox();
        jLabel20 = new javax.swing.JLabel();
        jcmbx_razonbaja = new javax.swing.JComboBox();
        jLabel18 = new javax.swing.JLabel();
        jtf_codigoidentifica = new javax.swing.JTextField();
        jchbx_verificacodigo = new javax.swing.JCheckBox();
        jdc_fechaingreso = new com.toedter.calendar.JDateChooser();
        jLabel32 = new javax.swing.JLabel();
        jlbl_diasemingreso = new javax.swing.JLabel();
        jLabel42 = new javax.swing.JLabel();
        jdc_fechabaja = new com.toedter.calendar.JDateChooser();
        jbtn_bajaempleado = new javax.swing.JButton();
        jLabel54 = new javax.swing.JLabel();
        jtf_asist_horaent_pro = new javax.swing.JFormattedTextField();
        jLabel55 = new javax.swing.JLabel();
        jftf_asist_salidaprog = new javax.swing.JFormattedTextField();
        jLabel56 = new javax.swing.JLabel();
        jtf_minutoscomida = new javax.swing.JTextField();
        jLabel57 = new javax.swing.JLabel();
        jtf_asist_horaen_dcom = new javax.swing.JFormattedTextField();
        jLabel58 = new javax.swing.JLabel();
        jtf_asist_horasa_dcom = new javax.swing.JFormattedTextField();
        jcmbx_ope_diadescanso = new javax.swing.JComboBox();
        jLabel59 = new javax.swing.JLabel();
        jLabel17 = new javax.swing.JLabel();
        jrbtn_sexomasculino = new javax.swing.JRadioButton();
        jrbtn_sexofemenino = new javax.swing.JRadioButton();
        jLabel22 = new javax.swing.JLabel();
        jcmbx_stadocivil = new javax.swing.JComboBox();
        jbtn_guardacambios = new javax.swing.JButton();
        jbtn_salir = new javax.swing.JButton();
        jbtn_ayuda = new javax.swing.JButton();
        jLabel33 = new javax.swing.JLabel();
        jdc_fechanaci = new com.toedter.calendar.JDateChooser();
        jPanel2 = new javax.swing.JPanel();
        jpn_colaboradorhisto = new javax.swing.JPanel();
        jScrollPane6 = new javax.swing.JScrollPane();
        jt_catempleadoshisto = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jCheckBox1 = new javax.swing.JCheckBox();
        jpn_resxareaevaluada = new javax.swing.JPanel();
        jScrollPane3 = new javax.swing.JScrollPane();
        jt_catresxarea = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jpn_detallerespuestas = new javax.swing.JPanel();
        jScrollPane2 = new javax.swing.JScrollPane();
        jt_catpreguntas = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jPanel8 = new javax.swing.JPanel();
        jScrollPane7 = new javax.swing.JScrollPane();
        jep_expediente = new javax.swing.JEditorPane();
        jScrollPane4 = new javax.swing.JScrollPane();
        jta_addexpediente = new javax.swing.JEditorPane();
        jbtn_guardar = new javax.swing.JButton();
        jLabel24 = new javax.swing.JLabel();
        jPanel16 = new javax.swing.JPanel();
        jdc_fechaaviso = new com.toedter.calendar.JDateChooser();
        jLabel40 = new javax.swing.JLabel();
        jtf_describeaviso = new javax.swing.JTextField();
        jLabel41 = new javax.swing.JLabel();
        jbtn_guardaraviso = new javax.swing.JButton();
        jPanel9 = new javax.swing.JPanel();
        jpn_colaboradorhisto1 = new javax.swing.JPanel();
        jScrollPane8 = new javax.swing.JScrollPane();
        jt_historialventa = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jcxb_graficaventa = new javax.swing.JCheckBox();
        jPanel10 = new javax.swing.JPanel();
        jpn_colaboradorhisto2 = new javax.swing.JPanel();
        jScrollPane10 = new javax.swing.JScrollPane();
        jt_historialasistencia = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jLabel34 = new javax.swing.JLabel();
        jdc_fechafinal = new com.toedter.calendar.JDateChooser();
        jdc_fechainicial = new com.toedter.calendar.JDateChooser();
        jLabel25 = new javax.swing.JLabel();
        jbtn_asist_buscar = new javax.swing.JButton();
        jPanel15 = new javax.swing.JPanel();
        jScrollPane11 = new javax.swing.JScrollPane();
        jt_historialasistencia_detalle = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jLabel35 = new javax.swing.JLabel();
        jtf_asis_fechaasis = new javax.swing.JTextField();
        jLabel36 = new javax.swing.JLabel();
        jcmbx_asist_status = new javax.swing.JComboBox();
        jftf_asist_horaentrada = new javax.swing.JFormattedTextField();
        jLabel37 = new javax.swing.JLabel();
        jLabel38 = new javax.swing.JLabel();
        jftf_asist_horasalida = new javax.swing.JFormattedTextField();
        jLabel39 = new javax.swing.JLabel();
        jScrollPane12 = new javax.swing.JScrollPane();
        jep_asist_boservaciones = new javax.swing.JEditorPane();
        jbtn_asistenciarev = new javax.swing.JButton();
        jftf_asist_id = new javax.swing.JFormattedTextField();
        jbtn_asist_guardarcambios = new javax.swing.JButton();
        jPanel3 = new javax.swing.JPanel();
        jPanel17 = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        jtf_sueldobase1 = new javax.swing.JTextField();
        jLabel43 = new javax.swing.JLabel();
        jtf_sueldobase2 = new javax.swing.JTextField();
        jLabel44 = new javax.swing.JLabel();
        jcmbx_idrazonsocial = new javax.swing.JComboBox();
        jtf_sueldobase3 = new javax.swing.JTextField();
        jLabel45 = new javax.swing.JLabel();
        jtf_sueldobase4 = new javax.swing.JTextField();
        jLabel46 = new javax.swing.JLabel();
        jButton1 = new javax.swing.JButton();
        jLabel47 = new javax.swing.JLabel();
        jtf_sueldobase5 = new javax.swing.JTextField();
        jLabel48 = new javax.swing.JLabel();
        jtf_empleadorfc = new javax.swing.JTextField();
        jLabel49 = new javax.swing.JLabel();
        jtf_empleadocurp = new javax.swing.JTextField();
        jLabel50 = new javax.swing.JLabel();
        jtf_empleadoimss = new javax.swing.JTextField();
        jLabel51 = new javax.swing.JLabel();
        jcmbx_idrazonsocialnof = new javax.swing.JComboBox();
        jdc_fechaingreso1 = new com.toedter.calendar.JDateChooser();
        jLabel52 = new javax.swing.JLabel();
        jLabel53 = new javax.swing.JLabel();
        jdc_fechaingresoimss = new com.toedter.calendar.JDateChooser();
        jcmbx_idrazonclasif = new javax.swing.JComboBox();
        jLabel60 = new javax.swing.JLabel();
        jcmbx_idesquema = new javax.swing.JComboBox();
        jLabel67 = new javax.swing.JLabel();
        jPanel19 = new javax.swing.JPanel();
        jScrollPane13 = new javax.swing.JScrollPane();
        jt_nomina_peryded = new javax.swing.JTable()
        {
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                return false;
            }
        }
        ;
        jLabel61 = new javax.swing.JLabel();
        jtf_idpod = new javax.swing.JTextField();
        jtf_idpoddescripcion = new javax.swing.JTextField();
        jLabel62 = new javax.swing.JLabel();
        jtf_idpodcantidad = new javax.swing.JTextField();
        jLabel63 = new javax.swing.JLabel();
        jtf_idpodfactor = new javax.swing.JTextField();
        jLabel64 = new javax.swing.JLabel();
        jtf_idpodsalario = new javax.swing.JTextField();
        jbtn_agregarpodind = new javax.swing.JButton();
        jtf_idpodimporte = new javax.swing.JTextField();
        jLabel65 = new javax.swing.JLabel();
        jLabel66 = new javax.swing.JLabel();
        jtf_idpodsalarioreal = new javax.swing.JTextField();
        jPanel18 = new javax.swing.JPanel();
        jScrollPane14 = new javax.swing.JScrollPane();
        jtb_documento_preparainsu = new javax.swing.JTable(){
            public boolean isCellEditable(int rowIndex, int mColIndex) {
                if (mColIndex>0)
                {
                    return false;
                }
                else
                {
                    return true;
                }
            }}
            ;
            jchbx_eliminarmodelo = new javax.swing.JCheckBox();
            jPanel20 = new javax.swing.JPanel();
            jLabel68 = new javax.swing.JLabel();
            jcmbx_idrazonclasif1 = new javax.swing.JComboBox();
            jbtn_asignarplaza = new javax.swing.JButton();
            jLabel69 = new javax.swing.JLabel();
            jdc_fechaingreso2 = new com.toedter.calendar.JDateChooser();
            jPanel4 = new javax.swing.JPanel();
            jLabel2 = new javax.swing.JLabel();
            jPanel11 = new javax.swing.JPanel();
            jcbx_tiendas = new javax.swing.JComboBox();
            jLabel26 = new javax.swing.JLabel();
            jtf_sieuno = new javax.swing.JTextField();
            jLabel27 = new javax.swing.JLabel();
            jbtn_buscarsieuno = new javax.swing.JButton();
            jPanel12 = new javax.swing.JPanel();
            jPanel13 = new javax.swing.JPanel();
            jScrollPane5 = new javax.swing.JScrollPane();
            jt_empleadocxc = new javax.swing.JTable()
            {
                public boolean isCellEditable(int rowIndex, int mColIndex) {
                    return false;
                }
            }
            ;
            jbtn_guardarcxcmovi = new javax.swing.JButton();
            jcmbx_concepto = new javax.swing.JComboBox();
            jLabel28 = new javax.swing.JLabel();
            jLabel29 = new javax.swing.JLabel();
            jtf_importe = new javax.swing.JTextField();
            jLabel30 = new javax.swing.JLabel();
            jtf_documentocxc = new javax.swing.JTextField();
            jLabel31 = new javax.swing.JLabel();
            jtf_boservacionescxc = new javax.swing.JTextField();
            jPanel14 = new javax.swing.JPanel();
            jScrollPane9 = new javax.swing.JScrollPane();
            jt_empleadocxcdetalle = new javax.swing.JTable()
            {
                public boolean isCellEditable(int rowIndex, int mColIndex) {
                    return false;
                }
            }
            ;
            jMenuBar1 = new javax.swing.JMenuBar();
            jMenu1 = new javax.swing.JMenu();
            jmni_salir = new javax.swing.JMenuItem();
            jMenu2 = new javax.swing.JMenu();
            jmni_escape = new javax.swing.JMenuItem();

            setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);

            jTabbedPane1.addChangeListener(new javax.swing.event.ChangeListener() {
                public void stateChanged(javax.swing.event.ChangeEvent evt) {
                    jTabbedPane1StateChanged(evt);
                }
            });

            jLabel3.setText("Id");

            jtf_empid.setEditable(false);

            jLabel4.setText("Status");

            jtf_empestatus.setEditable(false);

            jLabel5.setText("Nombre:");

            jtf_empnombre.setToolTipText("Ingrese Nombre o Nombres de Empleado Ej. CARLOS ALBERTO");
            jtf_empnombre.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empnombreActionPerformed(evt);
                }
            });

            jtf_empapat.setToolTipText("Ingrese Apellido Paterno Ej. VAZQUEZ");
            jtf_empapat.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empapatActionPerformed(evt);
                }
            });

            jLabel6.setText("A.Pat.");

            jLabel7.setText("A.Mat.");

            jtf_empamat.setToolTipText("Ingrese Apellido Materno Ej. RUIZ");
            jtf_empamat.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empamatActionPerformed(evt);
                }
            });

            jPanel5.setBorder(javax.swing.BorderFactory.createTitledBorder("Domicilio"));

            jLabel8.setText("Calle y Numero:");

            jLabel9.setText("Colonia:");

            jLabel10.setText("Poblacion:");

            jLabel11.setText("Codigo Postal:");

            jLabel12.setText("Telefono:");

            jtf_domcalle.setEditable(false);
            jtf_domcalle.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_domcalleActionPerformed(evt);
                }
            });

            jtf_domcolonia.setEditable(false);
            jtf_domcolonia.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_domcoloniaActionPerformed(evt);
                }
            });

            jtf_dompobla.setEditable(false);
            jtf_dompobla.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_dompoblaActionPerformed(evt);
                }
            });

            jtf_domcod.setEditable(false);
            jtf_domcod.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_domcodActionPerformed(evt);
                }
            });

            jtf_domtelefono.setEditable(false);
            jtf_domtelefono.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_domtelefonoActionPerformed(evt);
                }
            });

            jLabel21.setText("Foto:");

            jtf_empfoto.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empfotoActionPerformed(evt);
                }
            });

            jLabel23.setText("Email:");

            jtf_email.setEditable(false);
            jtf_email.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_emailActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jPanel5Layout = new javax.swing.GroupLayout(jPanel5);
            jPanel5.setLayout(jPanel5Layout);
            jPanel5Layout.setHorizontalGroup(
                jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel5Layout.createSequentialGroup()
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel5Layout.createSequentialGroup()
                            .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jLabel8)
                                .addComponent(jLabel9)
                                .addComponent(jLabel10)
                                .addComponent(jLabel21))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jtf_domcalle, javax.swing.GroupLayout.DEFAULT_SIZE, 270, Short.MAX_VALUE)
                                .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                    .addComponent(jtf_dompobla, javax.swing.GroupLayout.Alignment.LEADING)
                                    .addComponent(jtf_domcolonia, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.PREFERRED_SIZE, 184, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addComponent(jtf_empfoto, javax.swing.GroupLayout.PREFERRED_SIZE, 120, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addGroup(jPanel5Layout.createSequentialGroup()
                            .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jLabel11)
                                .addComponent(jLabel23))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(jPanel5Layout.createSequentialGroup()
                                    .addComponent(jtf_domcod, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jLabel12)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_domtelefono, javax.swing.GroupLayout.DEFAULT_SIZE, 183, Short.MAX_VALUE))
                                .addComponent(jtf_email, javax.swing.GroupLayout.DEFAULT_SIZE, 277, Short.MAX_VALUE))))
                    .addContainerGap())
            );
            jPanel5Layout.setVerticalGroup(
                jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel5Layout.createSequentialGroup()
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel8)
                        .addComponent(jtf_domcalle, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel9)
                        .addComponent(jtf_domcolonia, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel10)
                        .addComponent(jtf_dompobla, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel11)
                        .addComponent(jtf_domcod, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel12)
                        .addComponent(jtf_domtelefono, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel23)
                        .addComponent(jtf_email, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 18, Short.MAX_VALUE)
                    .addGroup(jPanel5Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel21)
                        .addComponent(jtf_empfoto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
            );

            jep_fotoempleado.setContentType("text/html");
            jep_fotoempleado.setEditable(false);
            jScrollPane1.setViewportView(jep_fotoempleado);

            javax.swing.GroupLayout jPanel6Layout = new javax.swing.GroupLayout(jPanel6);
            jPanel6.setLayout(jPanel6Layout);
            jPanel6Layout.setHorizontalGroup(
                jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel6Layout.createSequentialGroup()
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 265, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            );
            jPanel6Layout.setVerticalGroup(
                jPanel6Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 236, javax.swing.GroupLayout.PREFERRED_SIZE)
            );

            jPanel7.setBorder(javax.swing.BorderFactory.createTitledBorder("Datos Laborales"));

            jLabel13.setText("Departamento:");

            jLabel14.setText("Puesto:");

            jLabel15.setText("Clasificacion:");

            jLabel16.setText("Jefe Inmediato:");

            jLabel19.setText("Status:");

            jLabel20.setText("Razon baja:");

            jLabel18.setText("Codigo Identificacion:");

            jtf_codigoidentifica.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_codigoidentificaActionPerformed(evt);
                }
            });

            jchbx_verificacodigo.setText("Verificar Codigo");
            jchbx_verificacodigo.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jchbx_verificacodigoActionPerformed(evt);
                }
            });

            jdc_fechaingreso.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechaingreso.setDateFormatString("d-MM-yyyy");
            jdc_fechaingreso.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechaingresoKeyPressed(evt);
                }
            });

            jLabel32.setFont(new java.awt.Font("Tahoma 11", 1, 12));
            jLabel32.setText("Fecha Ingreso:");

            jlbl_diasemingreso.setFont(new java.awt.Font("Tahoma", 1, 11));
            jlbl_diasemingreso.setText("d");

            jLabel42.setFont(new java.awt.Font("Tahoma 11 12", 1, 12));
            jLabel42.setText("Fecha Baja:");

            jdc_fechabaja.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechabaja.setDateFormatString("d-MM-yyyy");
            jdc_fechabaja.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechabajaKeyPressed(evt);
                }
            });

            jbtn_bajaempleado.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/cancel.png"))); // NOI18N
            jbtn_bajaempleado.setText("Dar de Baja");
            jbtn_bajaempleado.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_bajaempleadoActionPerformed(evt);
                }
            });

            jLabel54.setText("Entrada:");

            jtf_asist_horaent_pro.setText("09:30");
            jtf_asist_horaent_pro.setToolTipText("Especificar hora de 0 a 24 ejm 8pm=20:00 hrs");
            jtf_asist_horaent_pro.setFont(new java.awt.Font("Tahoma 12", 1, 12));
            jtf_asist_horaent_pro.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_asist_horaent_proActionPerformed(evt);
                }
            });

            jLabel55.setText("H.Salida");

            jftf_asist_salidaprog.setText("14:00");
            jftf_asist_salidaprog.setToolTipText("Especificar hora de 0 a 24 ejm 8pm=20:00 hrs");
            jftf_asist_salidaprog.setFont(new java.awt.Font("Tahoma 12", 1, 12));
            jftf_asist_salidaprog.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jftf_asist_salidaprogActionPerformed(evt);
                }
            });

            jLabel56.setText("Min. Comida");

            jtf_minutoscomida.setFont(new java.awt.Font("Tahoma 12", 1, 12));
            jtf_minutoscomida.setText("120");
            jtf_minutoscomida.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_minutoscomidaActionPerformed(evt);
                }
            });

            jLabel57.setText("H.Entrada:");

            jtf_asist_horaen_dcom.setText("16:00");
            jtf_asist_horaen_dcom.setToolTipText("Especificar hora ej. 2pm=14:00,3pm=15:00,4pm=16:00");
            jtf_asist_horaen_dcom.setFont(new java.awt.Font("Tahoma 12", 1, 12));
            jtf_asist_horaen_dcom.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_asist_horaen_dcomActionPerformed(evt);
                }
            });

            jLabel58.setText("H.Salida");

            jtf_asist_horasa_dcom.setText("20:00");
            jtf_asist_horasa_dcom.setToolTipText("Especificar hora 6pm=18:00, 7pm=19:00,8pm=20:00,9pm=21:00");
            jtf_asist_horasa_dcom.setFont(new java.awt.Font("Tahoma 12", 1, 12));
            jtf_asist_horasa_dcom.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_asist_horasa_dcomActionPerformed(evt);
                }
            });

            jcmbx_ope_diadescanso.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jcmbx_ope_diadescansoActionPerformed(evt);
                }
            });

            jLabel59.setText("Dia Descanso:");

            javax.swing.GroupLayout jPanel7Layout = new javax.swing.GroupLayout(jPanel7);
            jPanel7.setLayout(jPanel7Layout);
            jPanel7Layout.setHorizontalGroup(
                jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel7Layout.createSequentialGroup()
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel7Layout.createSequentialGroup()
                            .addComponent(jLabel18)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jtf_codigoidentifica, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jchbx_verificacodigo)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel32)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jdc_fechaingreso, javax.swing.GroupLayout.PREFERRED_SIZE, 97, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(42, 42, 42)
                            .addComponent(jlbl_diasemingreso))
                        .addGroup(jPanel7Layout.createSequentialGroup()
                            .addComponent(jLabel54, javax.swing.GroupLayout.PREFERRED_SIZE, 53, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_asist_horaent_pro, javax.swing.GroupLayout.PREFERRED_SIZE, 53, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel55)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jftf_asist_salidaprog, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(36, 36, 36)
                            .addComponent(jLabel56)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_minutoscomida, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jLabel57)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_asist_horaen_dcom, javax.swing.GroupLayout.PREFERRED_SIZE, 53, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel58)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_asist_horasa_dcom, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGroup(jPanel7Layout.createSequentialGroup()
                            .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel7Layout.createSequentialGroup()
                                    .addComponent(jLabel59)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jcmbx_ope_diadescanso, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel7Layout.createSequentialGroup()
                                    .addComponent(jLabel20)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jcmbx_razonbaja, javax.swing.GroupLayout.PREFERRED_SIZE, 167, javax.swing.GroupLayout.PREFERRED_SIZE)))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jLabel42)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jdc_fechabaja, javax.swing.GroupLayout.PREFERRED_SIZE, 142, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jbtn_bajaempleado))
                        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel7Layout.createSequentialGroup()
                            .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                .addGroup(jPanel7Layout.createSequentialGroup()
                                    .addComponent(jLabel13)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jcmbx_departamento, javax.swing.GroupLayout.PREFERRED_SIZE, 127, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel14))
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel7Layout.createSequentialGroup()
                                    .addComponent(jLabel15)
                                    .addGap(18, 18, 18)
                                    .addComponent(jcmbx_clasificacion, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(jPanel7Layout.createSequentialGroup()
                                    .addComponent(jcmbx_puesto, 0, 157, Short.MAX_VALUE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel16)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jcmbx_empjefeinme, 0, 115, Short.MAX_VALUE))
                                .addGroup(jPanel7Layout.createSequentialGroup()
                                    .addComponent(jLabel19)
                                    .addGap(5, 5, 5)
                                    .addComponent(jcmbx_status, javax.swing.GroupLayout.PREFERRED_SIZE, 155, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                    .addContainerGap())
            );
            jPanel7Layout.setVerticalGroup(
                jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel7Layout.createSequentialGroup()
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel13)
                        .addComponent(jcmbx_departamento, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel14)
                        .addComponent(jcmbx_puesto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel16)
                        .addComponent(jcmbx_empjefeinme, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jcmbx_clasificacion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel15)
                        .addComponent(jcmbx_status, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel19))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jlbl_diasemingreso)
                        .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel18)
                            .addComponent(jtf_codigoidentifica, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jchbx_verificacodigo))
                        .addComponent(jLabel32)
                        .addComponent(jdc_fechaingreso, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                        .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel20)
                            .addComponent(jcmbx_razonbaja, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel42))
                        .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jbtn_bajaempleado)
                            .addComponent(jdc_fechabaja, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jftf_asist_salidaprog, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel55)
                        .addComponent(jtf_asist_horaent_pro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel54)
                        .addComponent(jLabel56)
                        .addComponent(jtf_minutoscomida, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jtf_asist_horasa_dcom, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel58)
                        .addComponent(jtf_asist_horaen_dcom, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel57))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(jPanel7Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel59)
                        .addComponent(jcmbx_ope_diadescanso, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
            );

            jLabel17.setFont(new java.awt.Font("Tahoma", 1, 11));
            jLabel17.setText("Sexo:");

            jrbtn_sexomasculino.setText("Masculino");
            jrbtn_sexomasculino.setActionCommand("1");
            jrbtn_sexomasculino.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jrbtn_sexomasculinoActionPerformed(evt);
                }
            });

            jrbtn_sexofemenino.setText("Femenino");
            jrbtn_sexofemenino.setActionCommand("2");
            jrbtn_sexofemenino.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jrbtn_sexofemeninoActionPerformed(evt);
                }
            });

            jLabel22.setText("Stado Civil:");

            jcmbx_stadocivil.setToolTipText("Selecciones Estado Civil");
            jcmbx_stadocivil.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jcmbx_stadocivilActionPerformed(evt);
                }
            });

            jbtn_guardacambios.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/database_save.png"))); // NOI18N
            jbtn_guardacambios.setText("<html> <U><b>G</b></U>uardar Cambios </html>");
            jbtn_guardacambios.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_guardacambiosActionPerformed(evt);
                }
            });

            jbtn_salir.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/door_out.png"))); // NOI18N
            jbtn_salir.setText("<html> <U><b>S</b></U>alir </html>");
            jbtn_salir.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_salirActionPerformed(evt);
                }
            });

            jbtn_ayuda.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/help.png"))); // NOI18N
            jbtn_ayuda.setText("<html> <U><b>A</b></U>yuda </html>");

            jLabel33.setFont(new java.awt.Font("Tahoma 11 12", 1, 12));
            jLabel33.setText("F. Nacimiento:");

            jdc_fechanaci.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechanaci.setDateFormatString("d-MM-yyyy");
            jdc_fechanaci.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechanaciKeyPressed(evt);
                }
            });

            javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
            jPanel1.setLayout(jPanel1Layout);
            jPanel1Layout.setHorizontalGroup(
                jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel1Layout.createSequentialGroup()
                    .addContainerGap()
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel1Layout.createSequentialGroup()
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addComponent(jLabel5)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_empnombre, javax.swing.GroupLayout.PREFERRED_SIZE, 124, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jLabel6)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_empapat, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel7)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_empamat))
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addComponent(jLabel3)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_empid, javax.swing.GroupLayout.PREFERRED_SIZE, 68, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jLabel4, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_empestatus, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel17)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jrbtn_sexomasculino)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jrbtn_sexofemenino)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jLabel22)))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jcmbx_stadocivil, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGroup(jPanel1Layout.createSequentialGroup()
                                    .addComponent(jLabel33)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jdc_fechanaci, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE))))
                        .addGroup(jPanel1Layout.createSequentialGroup()
                            .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGroup(jPanel1Layout.createSequentialGroup()
                            .addComponent(jbtn_guardacambios)
                            .addGap(81, 81, 81)
                            .addComponent(jbtn_salir)
                            .addGap(139, 139, 139)
                            .addComponent(jbtn_ayuda))
                        .addComponent(jPanel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addContainerGap(284, Short.MAX_VALUE))
            );
            jPanel1Layout.setVerticalGroup(
                jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel1Layout.createSequentialGroup()
                    .addContainerGap()
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel3)
                        .addComponent(jtf_empid, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel4)
                        .addComponent(jtf_empestatus, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel17)
                        .addComponent(jrbtn_sexomasculino)
                        .addComponent(jrbtn_sexofemenino)
                        .addComponent(jLabel22)
                        .addComponent(jcmbx_stadocivil, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel5)
                            .addComponent(jtf_empnombre, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel6)
                            .addComponent(jtf_empapat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel7)
                            .addComponent(jtf_empamat, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel33))
                        .addComponent(jdc_fechanaci, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jPanel5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jPanel6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(13, 13, 13)
                    .addComponent(jPanel7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jbtn_guardacambios)
                        .addComponent(jbtn_salir)
                        .addComponent(jbtn_ayuda))
                    .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("Datos Generales", jPanel1);

            jpn_colaboradorhisto.setBorder(javax.swing.BorderFactory.createTitledBorder("Historial para Este Colaborador"));

            jt_catempleadoshisto.setModel(this.jtable_modelo_empleado_hist);
            jt_catempleadoshisto.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_catempleadoshistoMouseClicked(evt);
                    if(evt.getClickCount() >= 2)
                    {
                        dioclickhisto(evt);
                        //System.out.println(" double click" );

                    }
                }
            });
            jScrollPane6.setViewportView(jt_catempleadoshisto);

            jCheckBox1.setText("Graficar");
            jCheckBox1.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jCheckBox1ActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jpn_colaboradorhistoLayout = new javax.swing.GroupLayout(jpn_colaboradorhisto);
            jpn_colaboradorhisto.setLayout(jpn_colaboradorhistoLayout);
            jpn_colaboradorhistoLayout.setHorizontalGroup(
                jpn_colaboradorhistoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jpn_colaboradorhistoLayout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jCheckBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(836, Short.MAX_VALUE))
                .addComponent(jScrollPane6, javax.swing.GroupLayout.DEFAULT_SIZE, 925, Short.MAX_VALUE)
            );
            jpn_colaboradorhistoLayout.setVerticalGroup(
                jpn_colaboradorhistoLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jpn_colaboradorhistoLayout.createSequentialGroup()
                    .addComponent(jScrollPane6, javax.swing.GroupLayout.DEFAULT_SIZE, 127, Short.MAX_VALUE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jCheckBox1, javax.swing.GroupLayout.PREFERRED_SIZE, 16, javax.swing.GroupLayout.PREFERRED_SIZE))
            );

            jpn_resxareaevaluada.setBorder(javax.swing.BorderFactory.createTitledBorder("Resultados X Area Evaluada"));

            jt_catresxarea.setModel(this.jtable_modelo_resxarea);
            jScrollPane3.setViewportView(jt_catresxarea);

            javax.swing.GroupLayout jpn_resxareaevaluadaLayout = new javax.swing.GroupLayout(jpn_resxareaevaluada);
            jpn_resxareaevaluada.setLayout(jpn_resxareaevaluadaLayout);
            jpn_resxareaevaluadaLayout.setHorizontalGroup(
                jpn_resxareaevaluadaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 920, Short.MAX_VALUE)
            );
            jpn_resxareaevaluadaLayout.setVerticalGroup(
                jpn_resxareaevaluadaLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 126, Short.MAX_VALUE)
            );

            jpn_detallerespuestas.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Detalle Respuestas", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.ABOVE_TOP));

            jt_catpreguntas.setModel(this.jtable_modelo);
            jt_catpreguntas.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_catpreguntasMouseClicked(evt);
                    if(evt.getClickCount() >= 2)
                    {
                        dioclick(evt);
                        //System.out.println(" double click" );

                    }
                }
            });
            jScrollPane2.setViewportView(jt_catpreguntas);

            javax.swing.GroupLayout jpn_detallerespuestasLayout = new javax.swing.GroupLayout(jpn_detallerespuestas);
            jpn_detallerespuestas.setLayout(jpn_detallerespuestasLayout);
            jpn_detallerespuestasLayout.setHorizontalGroup(
                jpn_detallerespuestasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 920, Short.MAX_VALUE)
            );
            jpn_detallerespuestasLayout.setVerticalGroup(
                jpn_detallerespuestasLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 139, javax.swing.GroupLayout.PREFERRED_SIZE)
            );

            javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
            jPanel2.setLayout(jPanel2Layout);
            jPanel2Layout.setHorizontalGroup(
                jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel2Layout.createSequentialGroup()
                    .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel2Layout.createSequentialGroup()
                            .addGap(5, 5, 5)
                            .addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jpn_detallerespuestas, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                .addComponent(jpn_resxareaevaluada, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)))
                        .addComponent(jpn_colaboradorhisto, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                    .addContainerGap())
            );
            jPanel2Layout.setVerticalGroup(
                jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel2Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jpn_colaboradorhisto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jpn_resxareaevaluada, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jpn_detallerespuestas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(23, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("Indicadores", jPanel2);

            jep_expediente.setContentType("text/html");
            jep_expediente.setEditable(false);
            jScrollPane7.setViewportView(jep_expediente);

            jScrollPane4.setViewportView(jta_addexpediente);

            jbtn_guardar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/add.png"))); // NOI18N
            jbtn_guardar.setText("<html>A<U><b>g</b></U>regar Nota:</html>");
            jbtn_guardar.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_guardarActionPerformed(evt);
                }
            });

            jLabel24.setText("Anotaciones:");

            jPanel16.setBorder(javax.swing.BorderFactory.createTitledBorder("Agregar Avisos"));

            jdc_fechaaviso.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechaaviso.setDateFormatString("d-MM-yyyy");
            jdc_fechaaviso.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechaavisoKeyPressed(evt);
                }
            });

            jLabel40.setText("Fecha:");

            jtf_describeaviso.setToolTipText("Ingrese aqui su Aviso");

            jLabel41.setText("Descripcion:");

            jbtn_guardaraviso.setText("Guardar Aviso");
            jbtn_guardaraviso.setToolTipText("Presione el Boton para Guardar Aviso");
            jbtn_guardaraviso.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_guardaravisoActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jPanel16Layout = new javax.swing.GroupLayout(jPanel16);
            jPanel16.setLayout(jPanel16Layout);
            jPanel16Layout.setHorizontalGroup(
                jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel16Layout.createSequentialGroup()
                    .addGroup(jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel16Layout.createSequentialGroup()
                            .addGap(2, 2, 2)
                            .addGroup(jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jLabel40)
                                .addComponent(jLabel41))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jtf_describeaviso, javax.swing.GroupLayout.PREFERRED_SIZE, 435, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jdc_fechaaviso, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)))
                        .addComponent(jbtn_guardaraviso))
                    .addContainerGap(30, Short.MAX_VALUE))
            );
            jPanel16Layout.setVerticalGroup(
                jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel16Layout.createSequentialGroup()
                    .addGroup(jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jdc_fechaaviso, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel40))
                    .addGap(18, 18, 18)
                    .addGroup(jPanel16Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jtf_describeaviso, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel41))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jbtn_guardaraviso)
                    .addContainerGap())
            );

            javax.swing.GroupLayout jPanel8Layout = new javax.swing.GroupLayout(jPanel8);
            jPanel8.setLayout(jPanel8Layout);
            jPanel8Layout.setHorizontalGroup(
                jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel8Layout.createSequentialGroup()
                    .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jScrollPane7, javax.swing.GroupLayout.DEFAULT_SIZE, 941, Short.MAX_VALUE)
                        .addGroup(jPanel8Layout.createSequentialGroup()
                            .addComponent(jLabel24)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 375, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jbtn_guardar, javax.swing.GroupLayout.PREFERRED_SIZE, 125, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addComponent(jPanel16, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addContainerGap())
            );
            jPanel8Layout.setVerticalGroup(
                jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel8Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jScrollPane7, javax.swing.GroupLayout.PREFERRED_SIZE, 307, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel8Layout.createSequentialGroup()
                            .addGap(14, 14, 14)
                            .addComponent(jLabel24))
                        .addGroup(jPanel8Layout.createSequentialGroup()
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel8Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jScrollPane4, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addComponent(jbtn_guardar))))
                    .addGap(34, 34, 34)
                    .addComponent(jPanel16, javax.swing.GroupLayout.DEFAULT_SIZE, 121, Short.MAX_VALUE)
                    .addContainerGap())
            );

            jTabbedPane1.addTab("Expediente Electronico", jPanel8);

            jpn_colaboradorhisto1.setBorder(javax.swing.BorderFactory.createTitledBorder("Historial para Este Colaborador"));

            jt_historialventa.setModel(this.jtable_modelo_empleado_ventasxmes);
            jt_catempleadoshisto.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_catempleadoshistoMouseClicked(evt);
                    if(evt.getClickCount() >= 2)
                    {
                        dioclickhisto(evt);
                        //System.out.println(" double click" );

                    }
                }
            });
            jScrollPane8.setViewportView(jt_historialventa);

            jcxb_graficaventa.setText("Graficar");
            jcxb_graficaventa.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jcxb_graficaventaActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jpn_colaboradorhisto1Layout = new javax.swing.GroupLayout(jpn_colaboradorhisto1);
            jpn_colaboradorhisto1.setLayout(jpn_colaboradorhisto1Layout);
            jpn_colaboradorhisto1Layout.setHorizontalGroup(
                jpn_colaboradorhisto1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jpn_colaboradorhisto1Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jcxb_graficaventa, javax.swing.GroupLayout.PREFERRED_SIZE, 83, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(826, Short.MAX_VALUE))
                .addComponent(jScrollPane8, javax.swing.GroupLayout.DEFAULT_SIZE, 915, Short.MAX_VALUE)
            );
            jpn_colaboradorhisto1Layout.setVerticalGroup(
                jpn_colaboradorhisto1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jpn_colaboradorhisto1Layout.createSequentialGroup()
                    .addComponent(jScrollPane8, javax.swing.GroupLayout.DEFAULT_SIZE, 217, Short.MAX_VALUE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jcxb_graficaventa, javax.swing.GroupLayout.PREFERRED_SIZE, 16, javax.swing.GroupLayout.PREFERRED_SIZE))
            );

            javax.swing.GroupLayout jPanel9Layout = new javax.swing.GroupLayout(jPanel9);
            jPanel9.setLayout(jPanel9Layout);
            jPanel9Layout.setHorizontalGroup(
                jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel9Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jpn_colaboradorhisto1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addContainerGap())
            );
            jPanel9Layout.setVerticalGroup(
                jPanel9Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel9Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jpn_colaboradorhisto1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(272, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("Historial Ventas", jPanel9);

            jpn_colaboradorhisto2.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "Asistencia", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Tahoma", 1, 11))); // NOI18N

            jt_historialasistencia.setModel(this.jtable_modelo_asistenciaxdia);
            jt_historialasistencia.setRowHeight(22);
            jt_historialasistencia.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_historialasistenciaMouseClicked(evt);
                    if(evt.getClickCount() >= 2)
                    {
                        dioclickasistedeta(evt);
                        //System.out.println(" double click" );

                    }
                }
            });
            jScrollPane10.setViewportView(jt_historialasistencia);

            jLabel34.setText("<html><b>F. Final:</b></html>");

            jdc_fechafinal.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechafinal.setDateFormatString("d-MM-yyyy");
            jdc_fechafinal.setMaxSelectableDate(new java.util.Date(253370790102000L));

            jdc_fechainicial.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechainicial.setDateFormatString("d-MM-yyyy");
            jdc_fechainicial.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechainicialKeyPressed(evt);
                }
            });

            jLabel25.setText("<html><b>F. Inicial:</b></html>");

            jbtn_asist_buscar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/find.png"))); // NOI18N
            jbtn_asist_buscar.setText("Buscar");
            jbtn_asist_buscar.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_asist_buscarActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jpn_colaboradorhisto2Layout = new javax.swing.GroupLayout(jpn_colaboradorhisto2);
            jpn_colaboradorhisto2.setLayout(jpn_colaboradorhisto2Layout);
            jpn_colaboradorhisto2Layout.setHorizontalGroup(
                jpn_colaboradorhisto2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jpn_colaboradorhisto2Layout.createSequentialGroup()
                    .addGap(70, 70, 70)
                    .addComponent(jLabel25)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jdc_fechainicial, javax.swing.GroupLayout.PREFERRED_SIZE, 112, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jLabel34, javax.swing.GroupLayout.PREFERRED_SIZE, 47, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jdc_fechafinal, javax.swing.GroupLayout.PREFERRED_SIZE, 117, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(32, 32, 32)
                    .addComponent(jbtn_asist_buscar)
                    .addContainerGap(399, Short.MAX_VALUE))
                .addComponent(jScrollPane10, javax.swing.GroupLayout.DEFAULT_SIZE, 935, Short.MAX_VALUE)
            );
            jpn_colaboradorhisto2Layout.setVerticalGroup(
                jpn_colaboradorhisto2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jpn_colaboradorhisto2Layout.createSequentialGroup()
                    .addGroup(jpn_colaboradorhisto2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jdc_fechafinal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel34, javax.swing.GroupLayout.PREFERRED_SIZE, 19, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jdc_fechainicial, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel25)
                        .addComponent(jbtn_asist_buscar))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jScrollPane10, javax.swing.GroupLayout.DEFAULT_SIZE, 314, Short.MAX_VALUE))
            );

            jPanel15.setBorder(javax.swing.BorderFactory.createTitledBorder("Detalle de Asistencia x Dia"));

            jt_historialasistencia_detalle.setModel(this.jtable_modelo_asistenciaxdia_detalle);
            jt_historialasistencia_detalle.setRowHeight(22);
            jScrollPane11.setViewportView(jt_historialasistencia_detalle);

            jLabel35.setText("Fecha:");

            jtf_asis_fechaasis.setEditable(false);

            jLabel36.setText("Status Asistencia:");

            jcmbx_asist_status.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jcmbx_asist_statusActionPerformed(evt);
                }
            });

            jftf_asist_horaentrada.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jftf_asist_horaentradaActionPerformed(evt);
                }
            });

            jLabel37.setText("H.Entrada:");

            jLabel38.setText("H.Salida");

            jftf_asist_horasalida.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jftf_asist_horasalidaActionPerformed(evt);
                }
            });

            jLabel39.setText("Observaciones:");

            jep_asist_boservaciones.addFocusListener(new java.awt.event.FocusAdapter() {
                public void focusLost(java.awt.event.FocusEvent evt) {
                    jep_asist_boservacionesFocusLost(evt);
                }
            });
            jScrollPane12.setViewportView(jep_asist_boservaciones);

            jbtn_asistenciarev.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/accept.gif"))); // NOI18N
            jbtn_asistenciarev.setText("Revisado Ok");
            jbtn_asistenciarev.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_asistenciarevActionPerformed(evt);
                }
            });

            jftf_asist_id.setEditable(false);

            jbtn_asist_guardarcambios.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/find.png"))); // NOI18N
            jbtn_asist_guardarcambios.setText("<html> <U><b></b></U>Guardar Cambios </html>");
            jbtn_asist_guardarcambios.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_asist_guardarcambiosActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jPanel15Layout = new javax.swing.GroupLayout(jPanel15);
            jPanel15.setLayout(jPanel15Layout);
            jPanel15Layout.setHorizontalGroup(
                jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel15Layout.createSequentialGroup()
                    .addComponent(jftf_asist_id, javax.swing.GroupLayout.PREFERRED_SIZE, 25, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jLabel35)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jtf_asis_fechaasis, javax.swing.GroupLayout.PREFERRED_SIZE, 95, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jLabel36)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jcmbx_asist_status, javax.swing.GroupLayout.PREFERRED_SIZE, 138, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jLabel37)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jftf_asist_horaentrada, javax.swing.GroupLayout.PREFERRED_SIZE, 53, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jLabel38)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jftf_asist_horasalida, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jbtn_asist_guardarcambios)
                    .addGap(164, 164, 164))
                .addGroup(jPanel15Layout.createSequentialGroup()
                    .addComponent(jLabel39)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jScrollPane12)
                    .addGap(18, 18, 18)
                    .addComponent(jbtn_asistenciarev)
                    .addContainerGap())
                .addComponent(jScrollPane11, javax.swing.GroupLayout.DEFAULT_SIZE, 935, Short.MAX_VALUE)
            );
            jPanel15Layout.setVerticalGroup(
                jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel15Layout.createSequentialGroup()
                    .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jftf_asist_horaentrada, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jftf_asist_horasalida, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel38)
                        .addComponent(jLabel37)
                        .addComponent(jcmbx_asist_status, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel36)
                        .addComponent(jtf_asis_fechaasis, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel35)
                        .addComponent(jftf_asist_id, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jbtn_asist_guardarcambios))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel15Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                        .addComponent(jLabel39)
                        .addComponent(jbtn_asistenciarev)
                        .addComponent(jScrollPane12, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jScrollPane11, javax.swing.GroupLayout.DEFAULT_SIZE, 64, Short.MAX_VALUE))
            );

            javax.swing.GroupLayout jPanel10Layout = new javax.swing.GroupLayout(jPanel10);
            jPanel10.setLayout(jPanel10Layout);
            jPanel10Layout.setHorizontalGroup(
                jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jpn_colaboradorhisto2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jPanel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            );
            jPanel10Layout.setVerticalGroup(
                jPanel10Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel10Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jpn_colaboradorhisto2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jPanel15, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("Asistencia", jPanel10);

            jLabel1.setText("Sueldo:");

            jtf_sueldobase1.setText("0");
            jtf_sueldobase1.setToolTipText("Ingrese el Salario por dia");
            jtf_sueldobase1.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_sueldobase1ActionPerformed(evt);
                }
            });

            jLabel43.setText("S. Base C.");

            jtf_sueldobase2.setText("0");
            jtf_sueldobase2.setToolTipText("Ingrese Salario x dia");
            jtf_sueldobase2.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_sueldobase2ActionPerformed(evt);
                }
            });

            jLabel44.setText("R. social F:");

            jtf_sueldobase3.setText("0");
            jtf_sueldobase3.setToolTipText("Ingrese Salario x dia");
            jtf_sueldobase3.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_sueldobase3ActionPerformed(evt);
                }
            });

            jLabel45.setText("S. Nominal:");

            jtf_sueldobase4.setText("0");
            jtf_sueldobase4.setToolTipText("Ingrese Salario no usado");
            jtf_sueldobase4.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_sueldobase4ActionPerformed(evt);
                }
            });

            jLabel46.setText("Salario Comp.");

            jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/database_save.png"))); // NOI18N
            jButton1.setText("Guardar");
            jButton1.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jButton1ActionPerformed(evt);
                }
            });

            jLabel47.setText("S. Vales D.");

            jtf_sueldobase5.setText("0");
            jtf_sueldobase5.setToolTipText("Ingrese Salario para calcular vales despensa");
            jtf_sueldobase5.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_sueldobase5ActionPerformed(evt);
                }
            });

            jLabel48.setText("RFC:");

            jtf_empleadorfc.setToolTipText("Ingrese el Salario por dia");
            jtf_empleadorfc.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empleadorfcActionPerformed(evt);
                }
            });

            jLabel49.setText("Curp:");

            jtf_empleadocurp.setToolTipText("Ingrese el Salario por dia");
            jtf_empleadocurp.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empleadocurpActionPerformed(evt);
                }
            });

            jLabel50.setText("Afil.:");

            jtf_empleadoimss.setToolTipText("Ingrese el Salario por dia");
            jtf_empleadoimss.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_empleadoimssActionPerformed(evt);
                }
            });

            jLabel51.setText("R. social NO F:");

            jdc_fechaingreso1.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechaingreso1.setDateFormatString("d-MM-yyyy");
            jdc_fechaingreso1.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechaingreso1KeyPressed(evt);
                }
            });

            jLabel52.setFont(new java.awt.Font("Tahoma 11 12", 1, 12));
            jLabel52.setText("Fecha Ingreso:");

            jLabel53.setFont(new java.awt.Font("Tahoma 11 12 12", 1, 12));
            jLabel53.setText("F.alta Imss:");

            jdc_fechaingresoimss.setToolTipText("Asegurese de Ingresar fechas con -, LA / NO ESTA HABILITADA, SI LA FECHA ESTA EN ROJO, ESTA NO EXISTE");
            jdc_fechaingresoimss.setDateFormatString("d-MM-yyyy");
            jdc_fechaingresoimss.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechaingresoimssKeyPressed(evt);
                }
            });

            jLabel60.setText("Clasificacion Nomina:");

            jLabel67.setText("Esquema:");

            javax.swing.GroupLayout jPanel17Layout = new javax.swing.GroupLayout(jPanel17);
            jPanel17.setLayout(jPanel17Layout);
            jPanel17Layout.setHorizontalGroup(
                jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel17Layout.createSequentialGroup()
                    .addContainerGap()
                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                        .addGroup(jPanel17Layout.createSequentialGroup()
                            .addComponent(jLabel48)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_empleadorfc, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel49, javax.swing.GroupLayout.PREFERRED_SIZE, 50, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_empleadocurp, javax.swing.GroupLayout.PREFERRED_SIZE, 110, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jLabel50, javax.swing.GroupLayout.PREFERRED_SIZE, 39, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_empleadoimss)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 44, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_sueldobase1, javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel17Layout.createSequentialGroup()
                            .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel17Layout.createSequentialGroup()
                                    .addComponent(jLabel43)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_sueldobase2, javax.swing.GroupLayout.PREFERRED_SIZE, 62, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel17Layout.createSequentialGroup()
                                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addComponent(jLabel46)
                                            .addGap(24, 24, 24))
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addComponent(jLabel52)
                                            .addGap(18, 18, 18)))
                                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addGap(10, 10, 10)
                                            .addComponent(jdc_fechaingreso1, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE))
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                            .addComponent(jtf_sueldobase4, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(jPanel17Layout.createSequentialGroup()
                                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addComponent(jLabel45)
                                            .addGap(19, 19, 19)
                                            .addComponent(jtf_sueldobase3, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                            .addComponent(jLabel47)
                                            .addGap(24, 24, 24)
                                            .addComponent(jtf_sueldobase5, javax.swing.GroupLayout.PREFERRED_SIZE, 62, javax.swing.GroupLayout.PREFERRED_SIZE)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                            .addComponent(jLabel44))
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addGap(10, 10, 10)
                                            .addComponent(jLabel51)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                            .addComponent(jcmbx_idrazonsocialnof, javax.swing.GroupLayout.PREFERRED_SIZE, 231, javax.swing.GroupLayout.PREFERRED_SIZE)))
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(jPanel17Layout.createSequentialGroup()
                                            .addComponent(jLabel67)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                            .addComponent(jcmbx_idesquema, javax.swing.GroupLayout.PREFERRED_SIZE, 182, javax.swing.GroupLayout.PREFERRED_SIZE))
                                        .addComponent(jcmbx_idrazonsocial, 0, 196, Short.MAX_VALUE)))
                                .addGroup(jPanel17Layout.createSequentialGroup()
                                    .addGap(14, 14, 14)
                                    .addComponent(jLabel53)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jdc_fechaingresoimss, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel60)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jcmbx_idrazonclasif, javax.swing.GroupLayout.PREFERRED_SIZE, 177, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)))))
                    .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            );
            jPanel17Layout.setVerticalGroup(
                jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel17Layout.createSequentialGroup()
                    .addContainerGap()
                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel48)
                        .addComponent(jtf_empleadorfc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel49)
                        .addComponent(jtf_empleadocurp, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel50)
                        .addComponent(jtf_empleadoimss, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel1)
                        .addComponent(jtf_sueldobase1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel43)
                        .addComponent(jtf_sueldobase2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jtf_sueldobase3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel45)
                        .addComponent(jtf_sueldobase5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel47)
                        .addComponent(jLabel44)
                        .addComponent(jcmbx_idrazonsocial, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jtf_sueldobase4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel46)
                        .addComponent(jLabel51)
                        .addComponent(jcmbx_idrazonsocialnof, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel67)
                        .addComponent(jcmbx_idesquema, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addComponent(jdc_fechaingreso1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel52)
                        .addComponent(jdc_fechaingresoimss, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel53)
                        .addGroup(jPanel17Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jcmbx_idrazonclasif, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addComponent(jLabel60)
                            .addComponent(jButton1)))
                    .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            );

            jPanel19.setBorder(javax.swing.BorderFactory.createTitledBorder("Percepciones y Ducciones Disponibles"));

            jt_nomina_peryded.setModel(this.jtable_modelo_nominaperodeduc);
            jt_nomina_peryded.setRowHeight(22);
            jt_nomina_peryded.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_nomina_perydedMouseClicked(evt);
                    if(evt.getClickCount() >= 1)
                    {
                        dioclickpodind(evt);
                    }
                }
            });
            jScrollPane13.setViewportView(jt_nomina_peryded);

            jLabel61.setText("Id:");

            jtf_idpod.setEditable(false);

            jtf_idpoddescripcion.setEditable(false);

            jLabel62.setText("Cantidad:");

            jtf_idpodcantidad.setText("0");
            jtf_idpodcantidad.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_idpodcantidadActionPerformed(evt);
                }
            });

            jLabel63.setText("Factor");

            jtf_idpodfactor.setText("1");
            jtf_idpodfactor.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_idpodfactorActionPerformed(evt);
                }
            });

            jLabel64.setText("Salario:");

            jtf_idpodsalario.setEditable(false);
            jtf_idpodsalario.setText("0");
            jtf_idpodsalario.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_idpodsalarioActionPerformed(evt);
                }
            });

            jbtn_agregarpodind.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/add.png"))); // NOI18N
            jbtn_agregarpodind.setText("Agregar");
            jbtn_agregarpodind.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_agregarpodindActionPerformed(evt);
                }
            });

            jtf_idpodimporte.setEditable(false);
            jtf_idpodimporte.setText("0");

            jLabel65.setText("Importe:");

            jLabel66.setText("Salario:");

            jtf_idpodsalarioreal.setText("0");
            jtf_idpodsalarioreal.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jtf_idpodsalariorealActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jPanel19Layout = new javax.swing.GroupLayout(jPanel19);
            jPanel19.setLayout(jPanel19Layout);
            jPanel19Layout.setHorizontalGroup(
                jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel19Layout.createSequentialGroup()
                    .addGroup(jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                        .addComponent(jScrollPane13, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 461, Short.MAX_VALUE)
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel19Layout.createSequentialGroup()
                            .addComponent(jLabel61)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jtf_idpod, javax.swing.GroupLayout.PREFERRED_SIZE, 31, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jtf_idpoddescripcion, javax.swing.GroupLayout.DEFAULT_SIZE, 402, Short.MAX_VALUE))
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel19Layout.createSequentialGroup()
                            .addGroup(jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                                .addGroup(jPanel19Layout.createSequentialGroup()
                                    .addComponent(jLabel65)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(jtf_idpodimporte, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGroup(jPanel19Layout.createSequentialGroup()
                                    .addComponent(jLabel62)
                                    .addGap(2, 2, 2)
                                    .addComponent(jtf_idpodcantidad, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel63)
                                    .addGap(6, 6, 6)))
                            .addGroup(jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(jPanel19Layout.createSequentialGroup()
                                    .addGap(2, 2, 2)
                                    .addComponent(jtf_idpodfactor, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel64)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_idpodsalario, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jLabel66)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jtf_idpodsalarioreal, javax.swing.GroupLayout.PREFERRED_SIZE, 74, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGroup(jPanel19Layout.createSequentialGroup()
                                    .addGap(238, 238, 238)
                                    .addComponent(jbtn_agregarpodind)))))
                    .addContainerGap())
            );
            jPanel19Layout.setVerticalGroup(
                jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel19Layout.createSequentialGroup()
                    .addComponent(jScrollPane13, javax.swing.GroupLayout.DEFAULT_SIZE, 152, Short.MAX_VALUE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel61)
                        .addComponent(jtf_idpod, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jtf_idpoddescripcion, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel62)
                        .addComponent(jtf_idpodcantidad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jtf_idpodfactor, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel64)
                        .addComponent(jtf_idpodsalario, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel66)
                        .addComponent(jtf_idpodsalarioreal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel63))
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel19Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jbtn_agregarpodind)
                        .addComponent(jLabel65)
                        .addComponent(jtf_idpodimporte, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
            );

            jPanel18.setBorder(javax.swing.BorderFactory.createTitledBorder("Percepciones y deducciones del Empleado"));

            jtb_documento_preparainsu.setModel(this.jtable_modelo_nominaperodeducem);
            jScrollPane14.setViewportView(jtb_documento_preparainsu);

            jchbx_eliminarmodelo.setText("Eliminar Concepto Fijo");
            jchbx_eliminarmodelo.setToolTipText("Marca como articulo con estatus de baja, para poder ocultarlo, si desea activarlo busque el articulo especifico");
            jchbx_eliminarmodelo.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jchbx_eliminarmodeloActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jPanel18Layout = new javax.swing.GroupLayout(jPanel18);
            jPanel18.setLayout(jPanel18Layout);
            jPanel18Layout.setHorizontalGroup(
                jPanel18Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jScrollPane14, javax.swing.GroupLayout.DEFAULT_SIZE, 396, Short.MAX_VALUE)
                .addGroup(jPanel18Layout.createSequentialGroup()
                    .addComponent(jchbx_eliminarmodelo)
                    .addContainerGap())
            );
            jPanel18Layout.setVerticalGroup(
                jPanel18Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel18Layout.createSequentialGroup()
                    .addComponent(jScrollPane14, javax.swing.GroupLayout.PREFERRED_SIZE, 206, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jchbx_eliminarmodelo)
                    .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
            );

            jPanel20.setBorder(javax.swing.BorderFactory.createTitledBorder("Asignacion de Plaza"));

            jbtn_asignarplaza.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_asignarplazaActionPerformed(evt);
                }
            });

            jdc_fechaingreso2.addKeyListener(new java.awt.event.KeyAdapter() {
                public void keyPressed(java.awt.event.KeyEvent evt) {
                    jdc_fechaingreso2KeyPressed(evt);
                }
            });

            javax.swing.GroupLayout jPanel20Layout = new javax.swing.GroupLayout(jPanel20);
            jPanel20.setLayout(jPanel20Layout);
            jPanel20Layout.setHorizontalGroup(
                jPanel20Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel20Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jLabel68)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jcmbx_idrazonclasif1, javax.swing.GroupLayout.PREFERRED_SIZE, 325, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jLabel69)
                    .addGap(18, 18, 18)
                    .addComponent(jdc_fechaingreso2, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(57, 57, 57)
                    .addComponent(jbtn_asignarplaza, javax.swing.GroupLayout.PREFERRED_SIZE, 183, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(203, Short.MAX_VALUE))
            );
            jPanel20Layout.setVerticalGroup(
                jPanel20Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel20Layout.createSequentialGroup()
                    .addGroup(jPanel20Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
                        .addComponent(jbtn_asignarplaza, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jdc_fechaingreso2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jcmbx_idrazonclasif1)
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel20Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                            .addComponent(jLabel69)
                            .addComponent(jLabel68)))
                    .addContainerGap(31, Short.MAX_VALUE))
            );

            javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
            jPanel3.setLayout(jPanel3Layout);
            jPanel3Layout.setHorizontalGroup(
                jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
                    .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                        .addComponent(jPanel20, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jPanel17, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addGroup(jPanel3Layout.createSequentialGroup()
                            .addContainerGap()
                            .addComponent(jPanel19, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 48, Short.MAX_VALUE)
                            .addComponent(jPanel18, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addContainerGap())
            );
            jPanel3Layout.setVerticalGroup(
                jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel3Layout.createSequentialGroup()
                    .addComponent(jPanel17, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jPanel20, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                        .addComponent(jPanel19, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jPanel18, javax.swing.GroupLayout.DEFAULT_SIZE, 265, Short.MAX_VALUE))
                    .addContainerGap(60, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("Salario", jPanel3);

            jLabel2.setText("En Contruccion");

            javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
            jPanel4.setLayout(jPanel4Layout);
            jPanel4Layout.setHorizontalGroup(
                jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel4Layout.createSequentialGroup()
                    .addGap(53, 53, 53)
                    .addComponent(jLabel2)
                    .addContainerGap(826, Short.MAX_VALUE))
            );
            jPanel4Layout.setVerticalGroup(
                jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel4Layout.createSequentialGroup()
                    .addGap(97, 97, 97)
                    .addComponent(jLabel2)
                    .addContainerGap(437, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("Imss", jPanel4);

            jcbx_tiendas.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jcbx_tiendasActionPerformed(evt);
                }
            });

            jtf_sieuno.setEditable(false);

            jbtn_buscarsieuno.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_buscarsieunoActionPerformed(evt);
                }
            });

            javax.swing.GroupLayout jPanel11Layout = new javax.swing.GroupLayout(jPanel11);
            jPanel11.setLayout(jPanel11Layout);
            jPanel11Layout.setHorizontalGroup(
                jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel11Layout.createSequentialGroup()
                    .addContainerGap()
                    .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(jPanel11Layout.createSequentialGroup()
                            .addComponent(jLabel27)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(jtf_sieuno, javax.swing.GroupLayout.PREFERRED_SIZE, 68, javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addGap(32, 32, 32)
                            .addComponent(jbtn_buscarsieuno, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGroup(jPanel11Layout.createSequentialGroup()
                            .addComponent(jLabel26)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jcbx_tiendas, javax.swing.GroupLayout.PREFERRED_SIZE, 233, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addContainerGap(704, Short.MAX_VALUE))
            );
            jPanel11Layout.setVerticalGroup(
                jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel11Layout.createSequentialGroup()
                    .addGap(14, 14, 14)
                    .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel27)
                        .addComponent(jtf_sieuno, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jbtn_buscarsieuno, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(36, 36, 36)
                    .addGroup(jPanel11Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel26)
                        .addComponent(jcbx_tiendas, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addContainerGap(457, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("SIE", jPanel11);

            jPanel13.setBorder(javax.swing.BorderFactory.createTitledBorder("Detalle por Empleado de Cuentas X Cobras(Saldos)"));

            jt_empleadocxc.setModel(this.jtable_modelo_empleadocxc);
            jt_empleadocxc.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_empleadocxcMouseClicked(evt);
                    if(evt.getClickCount() >= 2)
                    {
                        dioclickabonar(evt);
                        //System.out.println(" double click" );
                    }
                }
            });
            jScrollPane5.setViewportView(jt_empleadocxc);

            jbtn_guardarcxcmovi.setText("Aplicar Movimiento");
            jbtn_guardarcxcmovi.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jbtn_guardarcxcmoviActionPerformed(evt);
                }
            });

            jLabel28.setText("Conceptos:");

            jLabel29.setText("Importe:");

            jLabel30.setText("Documento:");

            jtf_documentocxc.setFont(new java.awt.Font("Tahoma", 1, 11));

            jLabel31.setText("Observaciones:");

            jPanel14.setBorder(javax.swing.BorderFactory.createTitledBorder("Detalle de Documento"));

            jt_empleadocxcdetalle.setModel(this.jtable_modelo_empleadocxcdetalle);
            jt_empleadocxcdetalle.addMouseListener(new java.awt.event.MouseAdapter() {
                public void mouseClicked(java.awt.event.MouseEvent evt) {
                    jt_empleadocxcdetalleMouseClicked(evt);
                }
            });
            jScrollPane9.setViewportView(jt_empleadocxcdetalle);

            javax.swing.GroupLayout jPanel14Layout = new javax.swing.GroupLayout(jPanel14);
            jPanel14.setLayout(jPanel14Layout);
            jPanel14Layout.setHorizontalGroup(
                jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGap(0, 919, Short.MAX_VALUE)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jScrollPane9, javax.swing.GroupLayout.DEFAULT_SIZE, 919, Short.MAX_VALUE))
            );
            jPanel14Layout.setVerticalGroup(
                jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGap(0, 100, Short.MAX_VALUE)
                .addGroup(jPanel14Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jScrollPane9, javax.swing.GroupLayout.DEFAULT_SIZE, 100, Short.MAX_VALUE))
            );

            javax.swing.GroupLayout jPanel13Layout = new javax.swing.GroupLayout(jPanel13);
            jPanel13.setLayout(jPanel13Layout);
            jPanel13Layout.setHorizontalGroup(
                jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel13Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jLabel29)
                    .addGap(18, 18, 18)
                    .addComponent(jtf_importe, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jLabel31)
                    .addGap(4, 4, 4)
                    .addComponent(jtf_boservacionescxc, javax.swing.GroupLayout.DEFAULT_SIZE, 520, Short.MAX_VALUE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jbtn_guardarcxcmovi)
                    .addGap(19, 19, 19))
                .addGroup(jPanel13Layout.createSequentialGroup()
                    .addContainerGap()
                    .addComponent(jLabel28)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jcmbx_concepto, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(6, 6, 6)
                    .addComponent(jLabel30)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                    .addComponent(jtf_documentocxc, javax.swing.GroupLayout.PREFERRED_SIZE, 88, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(523, Short.MAX_VALUE))
                .addComponent(jPanel14, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                .addComponent(jScrollPane5, javax.swing.GroupLayout.DEFAULT_SIZE, 935, Short.MAX_VALUE)
            );
            jPanel13Layout.setVerticalGroup(
                jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel13Layout.createSequentialGroup()
                    .addComponent(jScrollPane5, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addComponent(jPanel14, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 85, Short.MAX_VALUE)
                    .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jLabel28)
                        .addComponent(jcmbx_concepto, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel30)
                        .addComponent(jtf_documentocxc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGap(18, 18, 18)
                    .addGroup(jPanel13Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                        .addComponent(jtf_importe, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel29)
                        .addComponent(jLabel31)
                        .addComponent(jbtn_guardarcxcmovi)
                        .addComponent(jtf_boservacionescxc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addContainerGap())
            );

            javax.swing.GroupLayout jPanel12Layout = new javax.swing.GroupLayout(jPanel12);
            jPanel12.setLayout(jPanel12Layout);
            jPanel12Layout.setHorizontalGroup(
                jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jPanel13, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
            );
            jPanel12Layout.setVerticalGroup(
                jPanel12Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(jPanel12Layout.createSequentialGroup()
                    .addComponent(jPanel13, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addContainerGap(45, Short.MAX_VALUE))
            );

            jTabbedPane1.addTab("cxp", jPanel12);

            jMenu1.setText("Archivo");

            jmni_salir.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_S, java.awt.event.InputEvent.ALT_MASK));
            jmni_salir.setIcon(new javax.swing.ImageIcon(getClass().getResource("/iconos/door_out.png"))); // NOI18N
            jmni_salir.setText("<html> <U><b>S</b></U>alir</html>");
            jmni_salir.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jmni_salirActionPerformed(evt);
                }
            });
            jMenu1.add(jmni_salir);

            jMenuBar1.add(jMenu1);

            jMenu2.setText("Edicion");

            jmni_escape.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_ESCAPE, 0));
            jmni_escape.setText("Escape");
            jmni_escape.addActionListener(new java.awt.event.ActionListener() {
                public void actionPerformed(java.awt.event.ActionEvent evt) {
                    jmni_escapeActionPerformed(evt);
                }
            });
            jMenu2.add(jmni_escape);

            jMenuBar1.add(jMenu2);

            setJMenuBar(jMenuBar1);

            javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
            getContentPane().setLayout(layout);
            layout.setHorizontalGroup(
                layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 956, Short.MAX_VALUE)
            );
            layout.setVerticalGroup(
                layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 576, javax.swing.GroupLayout.PREFERRED_SIZE)
            );

            pack();
        }// </editor-fold>//GEN-END:initComponents

    private void jtf_empnombreActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empnombreActionPerformed
        // TODO add your handling code here:
        this.jtf_empapat.requestFocus();
}//GEN-LAST:event_jtf_empnombreActionPerformed

    private void jtf_empapatActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empapatActionPerformed
        // TODO add your handling code here:
        this.jtf_empamat.requestFocus();
}//GEN-LAST:event_jtf_empapatActionPerformed

    private void jtf_empamatActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empamatActionPerformed
        // TODO add your handling code here:
        this.jtf_domcalle.requestFocus();
    }//GEN-LAST:event_jtf_empamatActionPerformed

    private void jtf_domcalleActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_domcalleActionPerformed
        // TODO add your handling code here:
        this.jtf_domcolonia.requestFocus();
    }//GEN-LAST:event_jtf_domcalleActionPerformed

    private void jtf_domcoloniaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_domcoloniaActionPerformed
        // TODO add your handling code here:
        this.jtf_dompobla.requestFocus();
    }//GEN-LAST:event_jtf_domcoloniaActionPerformed

    private void jtf_dompoblaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_dompoblaActionPerformed
        // TODO add your handling code here:
        this.jtf_domcod.requestFocus();
    }//GEN-LAST:event_jtf_dompoblaActionPerformed

    private void jtf_domcodActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_domcodActionPerformed
        // TODO add your handling code here:
        this.jtf_domtelefono.requestFocus();
    }//GEN-LAST:event_jtf_domcodActionPerformed

    private void jtf_domtelefonoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_domtelefonoActionPerformed
        // TODO add your handling code here:
        this.jtf_email.requestFocus();
    }//GEN-LAST:event_jtf_domtelefonoActionPerformed

    private void jtf_empfotoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empfotoActionPerformed
        // TODO add your handling code here:
        this.jcmbx_departamento.requestFocus();
    }//GEN-LAST:event_jtf_empfotoActionPerformed

    private void jtf_emailActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_emailActionPerformed
        // TODO add your handling code here:
        this.jtf_empfoto.requestFocus();
    }//GEN-LAST:event_jtf_emailActionPerformed

    private void jtf_codigoidentificaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_codigoidentificaActionPerformed
        // TODO add your handling code here:
        this.jtf_asist_horaent_pro.requestFocus();
    }//GEN-LAST:event_jtf_codigoidentificaActionPerformed

    private void jchbx_verificacodigoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jchbx_verificacodigoActionPerformed
        // TODO add your handling code here:
        if (this.jtf_codigoidentifica.getText().toString().length() > 0 ) {
            this.carga_datos_idbuscasieuno(this.jtf_codigoidentifica.getText().trim());
        }
}//GEN-LAST:event_jchbx_verificacodigoActionPerformed

    private void jdc_fechaingresoKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechaingresoKeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechaingresoKeyPressed

    private void jdc_fechabajaKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechabajaKeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechabajaKeyPressed

    private void jbtn_bajaempleadoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_bajaempleadoActionPerformed
        // TODO add your handling code here:
        this.guarda_empleado_baja();
}//GEN-LAST:event_jbtn_bajaempleadoActionPerformed

    private void jtf_asist_horaent_proActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_asist_horaent_proActionPerformed
        // TODO add your handling code here:
        this.jftf_asist_salidaprog.requestFocus();
}//GEN-LAST:event_jtf_asist_horaent_proActionPerformed

    private void jftf_asist_salidaprogActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jftf_asist_salidaprogActionPerformed
        // TODO add your handling code here:
        this.jtf_minutoscomida.requestFocus();
}//GEN-LAST:event_jftf_asist_salidaprogActionPerformed

    private void jtf_minutoscomidaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_minutoscomidaActionPerformed
        // TODO add your handling code here:
        this.jtf_asist_horaen_dcom.requestFocus();
}//GEN-LAST:event_jtf_minutoscomidaActionPerformed

    private void jtf_asist_horaen_dcomActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_asist_horaen_dcomActionPerformed
        // TODO add your handling code here:
        this.jtf_asist_horasa_dcom.requestFocus();
}//GEN-LAST:event_jtf_asist_horaen_dcomActionPerformed

    private void jtf_asist_horasa_dcomActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_asist_horasa_dcomActionPerformed
        // TODO add your handling code here:
        this.jcmbx_ope_diadescanso.requestFocus();
}//GEN-LAST:event_jtf_asist_horasa_dcomActionPerformed

    private void jcmbx_ope_diadescansoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcmbx_ope_diadescansoActionPerformed
        // TODO add your handling code here:
        //  this.jbtn_guardacambios.requestFocus();
}//GEN-LAST:event_jcmbx_ope_diadescansoActionPerformed

    private void jrbtn_sexomasculinoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jrbtn_sexomasculinoActionPerformed
        // TODO add your handling code here:
        sexo=Integer.parseInt(evt.getActionCommand().toString());
}//GEN-LAST:event_jrbtn_sexomasculinoActionPerformed

    private void jrbtn_sexofemeninoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jrbtn_sexofemeninoActionPerformed
        // TODO add your handling code here:
        sexo=Integer.parseInt(evt.getActionCommand().toString());
}//GEN-LAST:event_jrbtn_sexofemeninoActionPerformed

    private void jcmbx_stadocivilActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcmbx_stadocivilActionPerformed
        // TODO add your handling code here:
        this.jtf_empnombre.requestFocus();
    }//GEN-LAST:event_jcmbx_stadocivilActionPerformed

    private void jbtn_guardacambiosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_guardacambiosActionPerformed
        // TODO add your handling code here:
        if(JOptionPane.showConfirmDialog(null, "Estan Correctos sus Datos?")==0) {
            this.guarda_empleado();
        }
}//GEN-LAST:event_jbtn_guardacambiosActionPerformed

    private void jbtn_salirActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_salirActionPerformed
        // TODO add your handling code here:
        this.jmni_salirActionPerformed(evt);
}//GEN-LAST:event_jbtn_salirActionPerformed

    private void jdc_fechanaciKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechanaciKeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechanaciKeyPressed

    private void jCheckBox1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jCheckBox1ActionPerformed
        // TODO add your handling code here:
        this.contruir_grafica_resultados();
}//GEN-LAST:event_jCheckBox1ActionPerformed

    private void jbtn_guardarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_guardarActionPerformed
        // TODO add your handling code here:
        if(JOptionPane.showConfirmDialog(null, "Estan Correctos sus Datos?")==0) {
            this.expediente_add(this.jtf_empid.getText(), this.jta_addexpediente.getText().trim());
            this.carga_datos_expediente(this.jtf_empid.getText());
        } else {
            //this.jtf_clave.requestFocus();
        }
}//GEN-LAST:event_jbtn_guardarActionPerformed

    private void jdc_fechaavisoKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechaavisoKeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechaavisoKeyPressed

    private void jbtn_guardaravisoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_guardaravisoActionPerformed
        // TODO add your handling code here:
        if(JOptionPane.showConfirmDialog(null, "Estan Correctos sus Datos?")==0) {
            //this.expediente_add(this.jtf_empid.getText(), this.jta_addexpediente.getText().trim());
            this.avisos_add(this.jtf_empid.getText(), this.jtf_describeaviso.getText().trim().toUpperCase(), this.fechaamericana(this.jdc_fechaaviso.getDate()));

        } else {
            //this.jtf_clave.requestFocus();
        }
    }//GEN-LAST:event_jbtn_guardaravisoActionPerformed

    private void jcxb_graficaventaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcxb_graficaventaActionPerformed
        // TODO add your handling code here:
        this.contruir_grafica_ventasxmes();
}//GEN-LAST:event_jcxb_graficaventaActionPerformed

    private void jdc_fechainicialKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechainicialKeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechainicialKeyPressed

    private void jbtn_asist_buscarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_asist_buscarActionPerformed
        // TODO add your handling code here:
        if (si_variables.getnivelusu() < 3) {
            this.carga_datos_asistencia(13, this.jtf_empid.getText(),this.fechaamericana(this.jdc_fechainicial.getDate()),this.fechaamericana(this.jdc_fechafinal.getDate()));
        }
}//GEN-LAST:event_jbtn_asist_buscarActionPerformed

    private void jcmbx_asist_statusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcmbx_asist_statusActionPerformed
        // TODO add your handling code here:
        this.jftf_asist_horaentrada.requestFocus();
}//GEN-LAST:event_jcmbx_asist_statusActionPerformed

    private void jftf_asist_horaentradaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jftf_asist_horaentradaActionPerformed
        // TODO add your handling code here:
        this.jftf_asist_horasalida.requestFocus();
}//GEN-LAST:event_jftf_asist_horaentradaActionPerformed

    private void jftf_asist_horasalidaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jftf_asist_horasalidaActionPerformed
        // TODO add your handling code here:
        this.jep_asist_boservaciones.requestFocus();
}//GEN-LAST:event_jftf_asist_horasalidaActionPerformed

    private void jep_asist_boservacionesFocusLost(java.awt.event.FocusEvent evt) {//GEN-FIRST:event_jep_asist_boservacionesFocusLost
        // TODO add your handling code here:
        this.jbtn_asist_guardarcambios.requestFocus();
}//GEN-LAST:event_jep_asist_boservacionesFocusLost

    private void jbtn_asistenciarevActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_asistenciarevActionPerformed
        // TODO add your handling code here:
        if(JOptionPane.showConfirmDialog(null, "Desea Marcar Como Revisado?")==0) {
            String arreglo_statusasis[]=this.jcmbx_asist_status.getSelectedItem().toString().split(":");
            this.asistencia_actualiza(2, this.jftf_asist_id.getText(), this.jtf_empid.getText(), this.jep_asist_boservaciones.getText(),"0",this.jftf_asist_horaentrada.getText(),this.jftf_asist_horasalida.getText(),arreglo_statusasis[0], "");
            this.jt_historialasistencia.requestFocus();
            this.jt_historialasistencia.changeSelection(0, 0, true, false);
            this.jftf_asist_id.setText("");
            this.jtf_asis_fechaasis.setText("");
            this.jcmbx_asist_status.removeAllItems();
            this.jftf_asist_horaentrada.setText("00:00:00");
            this.jftf_asist_horasalida.setText("00:00:00");
            this.jep_asist_boservaciones.setText("");
        }
    }//GEN-LAST:event_jbtn_asistenciarevActionPerformed

    private void jbtn_asist_guardarcambiosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_asist_guardarcambiosActionPerformed
        // TODO add your handling code here:
        if(JOptionPane.showConfirmDialog(null, "Estan Correctos sus Datos?")==0) {
            String arreglo_statusasis[]=this.jcmbx_asist_status.getSelectedItem().toString().split(":");
            this.asistencia_actualiza(1, this.jftf_asist_id.getText(), this.jtf_empid.getText(), this.jep_asist_boservaciones.getText(),"0",this.jftf_asist_horaentrada.getText(),this.jftf_asist_horasalida.getText(),arreglo_statusasis[0], "");
            this.jt_historialasistencia.requestFocus();
            this.jt_historialasistencia.changeSelection(0, 0, true, false);
            this.jftf_asist_id.setText("");
            this.jtf_asis_fechaasis.setText("");
            this.jcmbx_asist_status.removeAllItems();
            this.jftf_asist_horaentrada.setText("00:00:00");
            this.jftf_asist_horasalida.setText("00:00:00");
            this.jep_asist_boservaciones.setText("");
        }
}//GEN-LAST:event_jbtn_asist_guardarcambiosActionPerformed

    private void jtf_sueldobase1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_sueldobase1ActionPerformed
        // TODO add your handling code here:
        this.jtf_sueldobase2.requestFocus();
}//GEN-LAST:event_jtf_sueldobase1ActionPerformed

    private void jtf_sueldobase2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_sueldobase2ActionPerformed
        // TODO add your handling code here:
        this.jtf_sueldobase3.requestFocus();
}//GEN-LAST:event_jtf_sueldobase2ActionPerformed

    private void jtf_sueldobase3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_sueldobase3ActionPerformed
        // TODO add your handling code here:
        this.jtf_sueldobase5.requestFocus();
}//GEN-LAST:event_jtf_sueldobase3ActionPerformed

    private void jtf_sueldobase4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_sueldobase4ActionPerformed
        // TODO add your handling code here:
        this.jtf_sueldobase5.requestFocus();
}//GEN-LAST:event_jtf_sueldobase4ActionPerformed

    private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
        // TODO add your handling code here:
        String arreglo_pa[]=this.jcmbx_idrazonsocial.getSelectedItem().toString().split(":");
        String arreglo_pa2[]=this.jcmbx_idrazonsocialnof.getSelectedItem().toString().split(":");
        String arreglo_pac[]=this.jcmbx_idrazonclasif.getSelectedItem().toString().split(":");
        String arreglo_esq[]=this.jcmbx_idesquema.getSelectedItem().toString().split(":");

        String pFechainimss="NULL",pfechaalta="NULL";

        SimpleDateFormat formato = new SimpleDateFormat("yyyy-MM-dd");
        if(this.jdc_fechaingreso1.getDate()!=null)
            pfechaalta = formato.format(this.jdc_fechaingreso1.getDate());//fecha final de reporte

        if(this.jdc_fechaingresoimss.getDate()!=null)
            pFechainimss ="''"+ formato.format(this.jdc_fechaingresoimss.getDate())+"''";//fecha final de reporte

        System.out.println(pFechainimss);

        if(JOptionPane.showConfirmDialog(null, "Estan Correctos sus Datos?")==0) {
            String  texto="select * from x1_supervision_empleados_actualiza_salario("+this.jtf_empid.getText()+",'"+arreglo_pa[0]+"','"+this.jtf_sueldobase1.getText().trim()+"','"+this.jtf_sueldobase2.getText().trim()+"','"+this.jtf_sueldobase3.getText().trim()+"','"+this.jtf_sueldobase4.getText().trim()+"','','"+this.jtf_empleadorfc.getText().trim()+"','"+this.jtf_empleadocurp.getText().trim()+"','"+this.jtf_empleadoimss.getText().trim()+"','"+this.jtf_sueldobase5.getText().trim()+"','"+arreglo_pa2[0]+"','"+pfechaalta+"','"+pFechainimss+"','"+arreglo_pac[0]+"','"+arreglo_esq[0]+"');",confirma="";
            System.out.println(texto);
            try {
                rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());

                while (rs.next()) {
                    confirma=rs.getString(1);
                }
            } catch(Exception e) {
                System.out.println(e.getMessage());
            }
            if (confirma.equals("1")) {

                JOptionPane.showMessageDialog(null,"Gracias Salarios Guardados Correctamente", "Sistema Integral Tareas",1);


            } else {
                JOptionPane.showMessageDialog(null,"Error Verifiqu con Administrador no se ha podido guardar", "Sistema Integral Error",1);

            }
        }
}//GEN-LAST:event_jButton1ActionPerformed

    private void jtf_sueldobase5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_sueldobase5ActionPerformed
        // TODO add your handling code here:
        this.jcmbx_idrazonsocial.requestFocus();
}//GEN-LAST:event_jtf_sueldobase5ActionPerformed

    private void jtf_empleadorfcActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empleadorfcActionPerformed
        // TODO add your handling code here:
        this.jtf_empleadocurp.requestFocus();
}//GEN-LAST:event_jtf_empleadorfcActionPerformed

    private void jtf_empleadocurpActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empleadocurpActionPerformed
        // TODO add your handling code here:
        this.jtf_empleadoimss.requestFocus();
}//GEN-LAST:event_jtf_empleadocurpActionPerformed

    private void jtf_empleadoimssActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_empleadoimssActionPerformed
        // TODO add your handling code here:
        this.jtf_sueldobase1.requestFocus();
}//GEN-LAST:event_jtf_empleadoimssActionPerformed

    private void jdc_fechaingreso1KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechaingreso1KeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechaingreso1KeyPressed

    private void jdc_fechaingresoimssKeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechaingresoimssKeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechaingresoimssKeyPressed

    private void jtf_idpodcantidadActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_idpodcantidadActionPerformed
        // TODO add your handling code here:
        float cantidad=0;
        DecimalFormat myFormat = new DecimalFormat("############.#####");
        cantidad=Float.valueOf(this.jtf_idpodcantidad.getText());
        if(cantidad>0) {
            this.jtf_idpodimporte.setText(myFormat.format((Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString()))*cantidad));
        } else {
            this.jtf_idpodimporte.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString())));
        }
        this.jtf_idpodfactor.requestFocus();
}//GEN-LAST:event_jtf_idpodcantidadActionPerformed

    private void jtf_idpodfactorActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_idpodfactorActionPerformed
        // TODO add your handling code here:
        float cantidad=0;
        DecimalFormat myFormat = new DecimalFormat("############.#####");
        cantidad=Float.valueOf(this.jtf_idpodcantidad.getText());
        if(cantidad>0) {
            this.jtf_idpodimporte.setText(myFormat.format((Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString()))*cantidad));
        } else {
            this.jtf_idpodimporte.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString())));
        }
        this.jtf_idpodsalario.requestFocus();
}//GEN-LAST:event_jtf_idpodfactorActionPerformed

    private void jtf_idpodsalarioActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_idpodsalarioActionPerformed
        // TODO add your handling code here:
        float cantidad=0;
        DecimalFormat myFormat = new DecimalFormat("############.#####");
        cantidad=Float.valueOf(this.jtf_idpodcantidad.getText());
        if(cantidad>0) {
            this.jtf_idpodimporte.setText(myFormat.format((Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString()))*cantidad));
        } else {
            this.jtf_idpodimporte.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString())));
        }

        this.jbtn_agregarpodind.requestFocus();
    }//GEN-LAST:event_jtf_idpodsalarioActionPerformed

    private void jbtn_agregarpodindActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_agregarpodindActionPerformed
        // TODO add your handling code here:
        float cantidad=0;
        String folio="",texto="";
        DecimalFormat myFormat = new DecimalFormat("############.#####");
        cantidad=Float.valueOf(this.jtf_idpodcantidad.getText());
        if(cantidad>0) {
            this.jtf_idpodimporte.setText(myFormat.format((Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString()))*cantidad));
        } else {
            this.jtf_idpodcantidad.setText("1");
            this.jtf_idpodimporte.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString())*1));
        }
        if (this.find_idpodemp(jtf_idpod.getText().toString())==0) {
            if (Float.valueOf(this.jtf_idpodfactor.getText())>0) {
                texto="select * from x1_supervision_empleados_peroded(1,'0','"+this.jtf_empid.getText().trim()+"','"+this.jtf_idpod.getText()+"','"+this.jtf_idpodcantidad.getText()+"','"+this.jtf_idpodfactor.getText()+"','"+this.jtf_idpodsalario.getText()+"','')";
                if(JOptionPane.showConfirmDialog(null, "Desea Agregar la Linea:"+this.jtf_idpoddescripcion.getText().trim().toUpperCase()+"?")==0) {
                    try {
                        rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
                        while (rs.next()) {
                            folio=rs.getString(1);
                        }
                    } catch(Exception e) {
                        System.out.println(e.getMessage());

                    }

                    jtable_modelo_nominaperodeducem.addRow(new Object[]{folio,this.jtf_idpod.getText(),this.jtf_idpoddescripcion.getText(),this.jtf_idpodcantidad.getText(),this.jtf_idpodfactor.getText(),this.jtf_idpodsalario.getText(),this.jtf_idpodimporte.getText()});

                }
            }
        } else {
            JOptionPane.showMessageDialog(null,"<html><h2>YA Existe  Percepcion o Deduccion:"+this.jtf_idpoddescripcion.getText()+"</h2></html>", "Sistema Integral(Empleado: Edicion)",1);
        }
    }//GEN-LAST:event_jbtn_agregarpodindActionPerformed

    private void jtf_idpodsalariorealActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jtf_idpodsalariorealActionPerformed
        // TODO add your handling code here:
        DecimalFormat myFormat = new DecimalFormat("############.#####");
        float cantidad=0;

        cantidad=Float.valueOf(this.jtf_idpodcantidad.getText());
        if(cantidad>0) {
            this.jtf_idpodfactor.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalarioreal.getText().toString())/Float.valueOf(this.jtf_idpodsalario.getText().toString())));
            this.jtf_idpodimporte.setText(myFormat.format((Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString()))*cantidad));
        } else {
            this.jtf_idpodfactor.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalarioreal.getText().toString())/Float.valueOf(this.jtf_idpodsalario.getText().toString())));
            this.jtf_idpodimporte.setText(myFormat.format(Float.valueOf(this.jtf_idpodsalario.getText().toString())*Float.valueOf(this.jtf_idpodfactor.getText().toString())));
        }

    }//GEN-LAST:event_jtf_idpodsalariorealActionPerformed

    private void jchbx_eliminarmodeloActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jchbx_eliminarmodeloActionPerformed
        // TODO add your handling code here:
        int fila = jtb_documento_preparainsu.getSelectedRow(),id=0;

        String texto="select * from x1_supervision_empleados_peroded(2,'"+jtable_modelo_nominaperodeducem.getValueAt(fila, 0).toString()+"','"+""+"','"+""+"','"+""+"','"+""+"','"+""+"','')";
        System.out.println(texto);
        if(JOptionPane.showConfirmDialog(null, "Desea Eliminar Concepto:?"+jtable_modelo_nominaperodeducem.getValueAt(fila, 2).toString()+"")==0) {
            try {
                rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());
                while (rs.next()) {
                    id=rs.getInt(1);
                }
            } catch(Exception e) {
                System.out.println(e.getMessage());
            }
            jtable_modelo_nominaperodeducem.removeRow(fila);
        }
}//GEN-LAST:event_jchbx_eliminarmodeloActionPerformed

    private void jbtn_asignarplazaActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_asignarplazaActionPerformed
        // TODO add your handling code here:
        String arreglo_pla[]=this.jcmbx_idrazonclasif1.getSelectedItem().toString().split(":");
        if(JOptionPane.showConfirmDialog(null, "<html><b><h2>Plaza:<br>"+arreglo_pla[1]+"<br> Estan Correctos sus Datos</h2></b></html>?")==0) {
            String  texto="select * from x1_supervision_empleados_actualiza_plaza(1,"+this.jtf_empid.getText()+","+arreglo_pla[0]+",'"+this.fechaamericana(this.jdc_fechaingreso2.getDate())+"','"+""+"','"+""+"','');",confirma="";
            System.out.println(texto);
            try {
                rs = x.sieuno_executediversosv2(texto,si_variables.getconexiongral());

                while (rs.next()) {
                    confirma=rs.getString(1);
                }
            } catch(Exception e) {
                System.out.println(e.getMessage());
            }
            if (confirma.equals("1")) {

                JOptionPane.showMessageDialog(null,"Gracias Plaza Asignada correctamente", "Sistema Integral Tareas",1);


            } else {
                JOptionPane.showMessageDialog(null,"Error Verifiqu con Administrador no se ha podido guardar", "Sistema Integral Error",1);

            }
        }
}//GEN-LAST:event_jbtn_asignarplazaActionPerformed

    private void jdc_fechaingreso2KeyPressed(java.awt.event.KeyEvent evt) {//GEN-FIRST:event_jdc_fechaingreso2KeyPressed
        // TODO add your handling code here:
}//GEN-LAST:event_jdc_fechaingreso2KeyPressed

    private void jcbx_tiendasActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jcbx_tiendasActionPerformed
        // TODO add your handling code here:
        if (controlcombo > 0 ) {
            String arreglo_idtie[]=null;
            arreglo_idtie=this.jcbx_tiendas.getSelectedItem().toString().split(":");
            this.sieuno_actualizatienda(arreglo_idtie[0],this.jtf_sieuno.getText().trim());
        }

        //this.jtfpruebados.setText(jtable_tiendas.getValueAt(indeceta, 0).toString());
}//GEN-LAST:event_jcbx_tiendasActionPerformed

    private void jbtn_buscarsieunoActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_buscarsieunoActionPerformed
        // TODO add your handling code here:
        this.carga_datos_idsieuno(this.jtf_codigoidentifica.getText());
}//GEN-LAST:event_jbtn_buscarsieunoActionPerformed

    private void jbtn_guardarcxcmoviActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jbtn_guardarcxcmoviActionPerformed
        // TODO add your handling code here:
        String arreglo_concepto[]=this.jcmbx_concepto.getSelectedItem().toString().split(":");
        DecimalFormat miformat = new DecimalFormat("###,###,###,###");
        float cantidad=0,totaldocto=0;
        int error=0;
        String abono=this.jtf_importe.getText();
        if((abono.length() > 0) && (this.jtf_documentocxc.getText().length() > 0)) {
            try{

                cantidad = Float.valueOf(abono);
                System.out.println("Ok esta bien");

            }catch (NumberFormatException nfe) {

                cantidad=0;
                error=1;
                System.out.println("ERROR");

            }
        }
        if (error==0) {
            if(JOptionPane.showConfirmDialog(null, "<html><h2>Abono A "+this.jtf_empnombre.getText()+" "+this.jtf_empapat.getText()+" "+this.jtf_empamat.getText()+":"+cantidad+",Es correcto?</h2></html>")==0) {
                this.agregardoctocxc_detalle(0, Integer.valueOf(this.jtf_empid.getText()),this.jtf_documentocxc.getText(),cantidad,this.jtf_boservacionescxc.getText().toUpperCase(),arreglo_concepto[0]);
                this.carga_datos_empleadocxc(6, this.jtf_empid.getText());
            }
        } else {
            JOptionPane.showMessageDialog(null,"Error!", "Ingrese Cantidad Numerica : Ayuda",1);
        }

    }//GEN-LAST:event_jbtn_guardarcxcmoviActionPerformed

    private void jTabbedPane1StateChanged(javax.swing.event.ChangeEvent evt) {//GEN-FIRST:event_jTabbedPane1StateChanged
        // TODO add your handling code here:
        indexactual=this.jTabbedPane1.getSelectedIndex();
        if((indexactual==3)&&(yacargueventas==0)) {
            yacargueventas=1;
            this.carga_datos_ventaxmes(Integer.valueOf(this.jtf_empid.getText()));
        }
        if((indexactual==8)&&(yacarguecxc==0)) {
            yacarguecxc=1;
            this.carga_datos_empleadocxc(6, this.jtf_empid.getText());
            this.loadcomboconceptoscxc();
        }
        if((indexactual==4)&&(yacargueasis==0)) {
            if (si_variables.getnivelusu() < 3) {

                yacargueasis=1;
                this.carga_datos_asistencia(13, this.jtf_empid.getText(),this.fechaamericana(this.jdc_fechainicial.getDate()),this.fechaamericana(this.jdc_fechafinal.getDate()));

            }
        }
        if((indexactual==5)&&(yacarguesal==0)) {
            yacarguesal=1;
            this.carga_datos_salario(this.jtf_empid.getText());
            this.loadcombo_razsocpatron();
            this.loadcombo_razsocpatron_clasif();
            this.carga_datos_internoperoded();
            this.carga_datos_podempleado();
            this.loadcombo_esquema();
        }
}//GEN-LAST:event_jTabbedPane1StateChanged

    private void jmni_salirActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jmni_salirActionPerformed
        // TODO add your handling code here:
         if(JOptionPane.showConfirmDialog(null, "Desea Salir?")==0)
                {
                    this.dispose();
                }
    }//GEN-LAST:event_jmni_salirActionPerformed

    private void jmni_escapeActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jmni_escapeActionPerformed
        // TODO add your handling code here:
        this.jmni_salirActionPerformed(evt);
    }//GEN-LAST:event_jmni_escapeActionPerformed
   private void jt_nomina_perydedMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
    }

    private void jt_historialasistenciaMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
    }

private void jt_catempleadoshistoMouseClicked(java.awt.event.MouseEvent evt) {
        // TODO add your handling code here:
    }

    /**
    * @param args the command line arguments
    */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                rh_empleados_edita dialog = new rh_empleados_edita(new javax.swing.JFrame(), true);
                dialog.addWindowListener(new java.awt.event.WindowAdapter() {
                    public void windowClosing(java.awt.event.WindowEvent e) {
                        System.exit(0);
                    }
                });
                dialog.setVisible(true);
            }
        });
    }

    // Variables declaration - do not modify//GEN-BEGIN:variables
    private javax.swing.ButtonGroup buttonGroup1;
    private javax.swing.JButton jButton1;
    private javax.swing.JCheckBox jCheckBox1;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel10;
    private javax.swing.JLabel jLabel11;
    private javax.swing.JLabel jLabel12;
    private javax.swing.JLabel jLabel13;
    private javax.swing.JLabel jLabel14;
    private javax.swing.JLabel jLabel15;
    private javax.swing.JLabel jLabel16;
    private javax.swing.JLabel jLabel17;
    private javax.swing.JLabel jLabel18;
    private javax.swing.JLabel jLabel19;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel20;
    private javax.swing.JLabel jLabel21;
    private javax.swing.JLabel jLabel22;
    private javax.swing.JLabel jLabel23;
    private javax.swing.JLabel jLabel24;
    private javax.swing.JLabel jLabel25;
    private javax.swing.JLabel jLabel26;
    private javax.swing.JLabel jLabel27;
    private javax.swing.JLabel jLabel28;
    private javax.swing.JLabel jLabel29;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabel30;
    private javax.swing.JLabel jLabel31;
    private javax.swing.JLabel jLabel32;
    private javax.swing.JLabel jLabel33;
    private javax.swing.JLabel jLabel34;
    private javax.swing.JLabel jLabel35;
    private javax.swing.JLabel jLabel36;
    private javax.swing.JLabel jLabel37;
    private javax.swing.JLabel jLabel38;
    private javax.swing.JLabel jLabel39;
    private javax.swing.JLabel jLabel4;
    private javax.swing.JLabel jLabel40;
    private javax.swing.JLabel jLabel41;
    private javax.swing.JLabel jLabel42;
    private javax.swing.JLabel jLabel43;
    private javax.swing.JLabel jLabel44;
    private javax.swing.JLabel jLabel45;
    private javax.swing.JLabel jLabel46;
    private javax.swing.JLabel jLabel47;
    private javax.swing.JLabel jLabel48;
    private javax.swing.JLabel jLabel49;
    private javax.swing.JLabel jLabel5;
    private javax.swing.JLabel jLabel50;
    private javax.swing.JLabel jLabel51;
    private javax.swing.JLabel jLabel52;
    private javax.swing.JLabel jLabel53;
    private javax.swing.JLabel jLabel54;
    private javax.swing.JLabel jLabel55;
    private javax.swing.JLabel jLabel56;
    private javax.swing.JLabel jLabel57;
    private javax.swing.JLabel jLabel58;
    private javax.swing.JLabel jLabel59;
    private javax.swing.JLabel jLabel6;
    private javax.swing.JLabel jLabel60;
    private javax.swing.JLabel jLabel61;
    private javax.swing.JLabel jLabel62;
    private javax.swing.JLabel jLabel63;
    private javax.swing.JLabel jLabel64;
    private javax.swing.JLabel jLabel65;
    private javax.swing.JLabel jLabel66;
    private javax.swing.JLabel jLabel67;
    private javax.swing.JLabel jLabel68;
    private javax.swing.JLabel jLabel69;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenu jMenu2;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel10;
    private javax.swing.JPanel jPanel11;
    private javax.swing.JPanel jPanel12;
    private javax.swing.JPanel jPanel13;
    private javax.swing.JPanel jPanel14;
    private javax.swing.JPanel jPanel15;
    private javax.swing.JPanel jPanel16;
    private javax.swing.JPanel jPanel17;
    private javax.swing.JPanel jPanel18;
    private javax.swing.JPanel jPanel19;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JPanel jPanel20;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JPanel jPanel5;
    private javax.swing.JPanel jPanel6;
    private javax.swing.JPanel jPanel7;
    private javax.swing.JPanel jPanel8;
    private javax.swing.JPanel jPanel9;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JScrollPane jScrollPane10;
    private javax.swing.JScrollPane jScrollPane11;
    private javax.swing.JScrollPane jScrollPane12;
    private javax.swing.JScrollPane jScrollPane13;
    private javax.swing.JScrollPane jScrollPane14;
    private javax.swing.JScrollPane jScrollPane2;
    private javax.swing.JScrollPane jScrollPane3;
    private javax.swing.JScrollPane jScrollPane4;
    private javax.swing.JScrollPane jScrollPane5;
    private javax.swing.JScrollPane jScrollPane6;
    private javax.swing.JScrollPane jScrollPane7;
    private javax.swing.JScrollPane jScrollPane8;
    private javax.swing.JScrollPane jScrollPane9;
    private javax.swing.JTabbedPane jTabbedPane1;
    private javax.swing.JButton jbtn_agregarpodind;
    private javax.swing.JButton jbtn_asignarplaza;
    private javax.swing.JButton jbtn_asist_buscar;
    private javax.swing.JButton jbtn_asist_guardarcambios;
    private javax.swing.JButton jbtn_asistenciarev;
    private javax.swing.JButton jbtn_ayuda;
    private javax.swing.JButton jbtn_bajaempleado;
    private javax.swing.JButton jbtn_buscarsieuno;
    private javax.swing.JButton jbtn_guardacambios;
    private javax.swing.JButton jbtn_guardar;
    private javax.swing.JButton jbtn_guardaraviso;
    private javax.swing.JButton jbtn_guardarcxcmovi;
    private javax.swing.JButton jbtn_salir;
    private javax.swing.JComboBox jcbx_tiendas;
    private javax.swing.JCheckBox jchbx_eliminarmodelo;
    private javax.swing.JCheckBox jchbx_verificacodigo;
    private javax.swing.JComboBox jcmbx_asist_status;
    private javax.swing.JComboBox jcmbx_clasificacion;
    private javax.swing.JComboBox jcmbx_concepto;
    private javax.swing.JComboBox jcmbx_departamento;
    private javax.swing.JComboBox jcmbx_empjefeinme;
    private javax.swing.JComboBox jcmbx_idesquema;
    private javax.swing.JComboBox jcmbx_idrazonclasif;
    private javax.swing.JComboBox jcmbx_idrazonclasif1;
    private javax.swing.JComboBox jcmbx_idrazonsocial;
    private javax.swing.JComboBox jcmbx_idrazonsocialnof;
    private javax.swing.JComboBox jcmbx_ope_diadescanso;
    private javax.swing.JComboBox jcmbx_puesto;
    private javax.swing.JComboBox jcmbx_razonbaja;
    private javax.swing.JComboBox jcmbx_stadocivil;
    private javax.swing.JComboBox jcmbx_status;
    private javax.swing.JCheckBox jcxb_graficaventa;
    private com.toedter.calendar.JDateChooser jdc_fechaaviso;
    private com.toedter.calendar.JDateChooser jdc_fechabaja;
    private com.toedter.calendar.JDateChooser jdc_fechafinal;
    private com.toedter.calendar.JDateChooser jdc_fechaingreso;
    private com.toedter.calendar.JDateChooser jdc_fechaingreso1;
    private com.toedter.calendar.JDateChooser jdc_fechaingreso2;
    private com.toedter.calendar.JDateChooser jdc_fechaingresoimss;
    private com.toedter.calendar.JDateChooser jdc_fechainicial;
    private com.toedter.calendar.JDateChooser jdc_fechanaci;
    private javax.swing.JEditorPane jep_asist_boservaciones;
    private javax.swing.JEditorPane jep_expediente;
    private javax.swing.JEditorPane jep_fotoempleado;
    private javax.swing.JFormattedTextField jftf_asist_horaentrada;
    private javax.swing.JFormattedTextField jftf_asist_horasalida;
    private javax.swing.JFormattedTextField jftf_asist_id;
    private javax.swing.JFormattedTextField jftf_asist_salidaprog;
    private javax.swing.JLabel jlbl_diasemingreso;
    private javax.swing.JMenuItem jmni_escape;
    private javax.swing.JMenuItem jmni_salir;
    private javax.swing.JPanel jpn_colaboradorhisto;
    private javax.swing.JPanel jpn_colaboradorhisto1;
    private javax.swing.JPanel jpn_colaboradorhisto2;
    private javax.swing.JPanel jpn_detallerespuestas;
    private javax.swing.JPanel jpn_resxareaevaluada;
    private javax.swing.JRadioButton jrbtn_sexofemenino;
    private javax.swing.JRadioButton jrbtn_sexomasculino;
    private javax.swing.JTable jt_catempleadoshisto;
    private javax.swing.JTable jt_catpreguntas;
    private javax.swing.JTable jt_catresxarea;
    private javax.swing.JTable jt_empleadocxc;
    private javax.swing.JTable jt_empleadocxcdetalle;
    private javax.swing.JTable jt_historialasistencia;
    private javax.swing.JTable jt_historialasistencia_detalle;
    private javax.swing.JTable jt_historialventa;
    private javax.swing.JTable jt_nomina_peryded;
    private javax.swing.JEditorPane jta_addexpediente;
    private javax.swing.JTable jtb_documento_preparainsu;
    private javax.swing.JTextField jtf_asis_fechaasis;
    private javax.swing.JFormattedTextField jtf_asist_horaen_dcom;
    private javax.swing.JFormattedTextField jtf_asist_horaent_pro;
    private javax.swing.JFormattedTextField jtf_asist_horasa_dcom;
    private javax.swing.JTextField jtf_boservacionescxc;
    private javax.swing.JTextField jtf_codigoidentifica;
    private javax.swing.JTextField jtf_describeaviso;
    private javax.swing.JTextField jtf_documentocxc;
    private javax.swing.JTextField jtf_domcalle;
    private javax.swing.JTextField jtf_domcod;
    private javax.swing.JTextField jtf_domcolonia;
    private javax.swing.JTextField jtf_dompobla;
    private javax.swing.JTextField jtf_domtelefono;
    private javax.swing.JTextField jtf_email;
    private javax.swing.JTextField jtf_empamat;
    private javax.swing.JTextField jtf_empapat;
    private javax.swing.JTextField jtf_empestatus;
    private javax.swing.JTextField jtf_empfoto;
    private javax.swing.JTextField jtf_empid;
    private javax.swing.JTextField jtf_empleadocurp;
    private javax.swing.JTextField jtf_empleadoimss;
    private javax.swing.JTextField jtf_empleadorfc;
    private javax.swing.JTextField jtf_empnombre;
    private javax.swing.JTextField jtf_idpod;
    private javax.swing.JTextField jtf_idpodcantidad;
    private javax.swing.JTextField jtf_idpoddescripcion;
    private javax.swing.JTextField jtf_idpodfactor;
    private javax.swing.JTextField jtf_idpodimporte;
    private javax.swing.JTextField jtf_idpodsalario;
    private javax.swing.JTextField jtf_idpodsalarioreal;
    private javax.swing.JTextField jtf_importe;
    private javax.swing.JTextField jtf_minutoscomida;
    private javax.swing.JTextField jtf_sieuno;
    private javax.swing.JTextField jtf_sueldobase1;
    private javax.swing.JTextField jtf_sueldobase2;
    private javax.swing.JTextField jtf_sueldobase3;
    private javax.swing.JTextField jtf_sueldobase4;
    private javax.swing.JTextField jtf_sueldobase5;
    // End of variables declaration//GEN-END:variables

}
